PGCon2016 - 20180510

PGCon 2016
The PostgreSQL Conference

Speakers
Álvaro Hernández
Schedule
Day Tutorials - Day 1 - 2016-05-17
Room MRT 251
Start time 13:00
Duration 03:00
Info
ID 972
Event type Workshop
Track Tutorial
Language used for presentation English

Hands-On Lab: New PostgreSQL 9.5 features

No bullshit: BYOL and try it out!

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

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