Monday 2:35 p.m.–3:05 p.m.
Postgres present and future
Craig Kerstiens
- Audience level:
- Intermediate
- Category:
- Databases
Description
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.
Abstract
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.
PyCon 2016 in Portland, OR is a production of the 