Hands-On Lab: New PostgreSQL 9.5 features

So you have heard already --or maybe not-- about all the new goodies that come with PostgreSQL 9.5. But have you put them to test? In production? Are you really taking advantage of all these new great features?

Join this hand-on lab to learn, by experience, what new features PostgreSQL 9.5 comes with, what to use them for, and how to use them. The format of the tutorial is a brief lecture-style introduction to the new features, followed by an extensive lab. The lab consists on a series of exercises, explained in a Lab guide, to be solved during the session, while the instructor will be available for questions and showcasing the solutions to the proposed exercises.

Among others, the following areas are addressed in this tutorial:

• UPSERT (aka INSERT … ON CONLIFCT)
• Row Level Security
• OLAP-like functions (GROUPING SETS, CUBE and ROLLUP)
• Update JSONB
• BRIN indexes
• TABLESAMPLE