PGCon2010 - Final Release III

PGCon 2010
The PostgreSQL Conference

Tim Bunce
Day Talks - 2 - 2010-05-21
Room DMS 1160
Start time 16:30
Duration 01:00
ID 207
Event type Lecture
Track Applications
Language used for presentation English

PL/Perl - new features in 9.0

Find out all you need to know about the new PL/Perl features in PostgreSQL 9.0

New features include:

  • New utility functions: quote_literal, quote_nullable, quote_ident, encode_bytea, decode_bytea, looks_like_number, encode_array_literal, encode_array_constructor.
  • The use and require commands can be used in plperl for modules that have already been loaded, like strict and warnings.
  • The features module is pre-loaded for perl 5.10+.
  • Better integration with tools like Devel::NYTProf.
  • END blocks and object destructors are run at session end.
  • Added plperl.on_init, plperl.on_plperl_init and plperl.on_plperlu_init GUCs for DBA use.

Your plperl functions can now use external Perl modules, if your DBA allows. I'll talk about the security implications of this.

I'll also demonstrate using Devel::NYTProf to performance profile your PL/Perl functions.