Monday 2:35 p.m.–3:05 p.m.
Postgres present and future
- Audience level:
Postgres 9.5 was just released a few months ago and has a number of of new improvements we'll walk through including new JSONB functions, some analytical tooling, and of course upsert. Then we'll dive into what's coming in Postgres 9.6, the next Postgres release. Finally, we'll round it out with some look at the ecosystem of extensions.
Postgres 9.5 was just released a few months ago (as of the time of the talk). It has a number of [new improvements](http://www.craigkerstiens.com/2015/12/27/postgres-9-5-feature-rundown/) including new JSONB functions, some analytical tooling, and of course upsert. We'll take a tour through each of these new features, how you use them with Python, Django, or just natively in SQL. Then we'll dive into what's coming in Postgres 9.6 as it will be nearly feature freeze timeframe you can start to know what's coming in the next 6 month timeframe. Finally we'll take a tour of some extensions. Extensions provide a great way to extend Postgres and the community around them has slowly built up over time. This includes [Hyperloglog](http://tapoueh.org/blog/2013/02/25-postgresql-hyperloglog), hypothetical indexes, [Citus](citusdata.com), and possibly more.