9 PostgreSQL features I wish I learned earlier

Postgres has a lot of cool & powerful features. In this talk I'll show you a few I wish I learned about earlier:

• .pg_service.conf
• pg_notify
• WITH queries
• WITH RECURSIVE queries
• REASSIGN OWNED

and some more things...

Slides:

• I edited the slides a lot for Perl Dancer 2016 (2016-09-22). The title is now "12 PostgreSQL features I wish I learned earlier and 4 I learned right away".
• At Alpine Perl Workshop 2016 I used the same slides as in Cluj (2016-09-02); Video
• Slides for the European Perl Conference aka YAPC::Europe 2016 (with a bit more bonus material) (2016-08-25); Video
• Slides for German Perl Workshop 2016 (2016-03-10)
• Slides for PostgresSQL conference Europe 2015 (2015-10-30)