Presented by:


Lukas Fittl

Citus Data

Principal Engineer on the Citus Cloud team at Citus Data, developing and operating a distributed PostgreSQL-as-a-Service.

Creator of, hosted PostgreSQL Performance Monitoring, author of pg_query (Ruby extension to parse queries using the raw_parser) and other tools. I love working with PostgreSQL statistics and visualizing them.

No video of the event yet, sorry!

PostgreSQL is a great database - yet there is an interesting set of issues you encounter when you have a team of developers working with an ever changing schema. At Product Hunt we've been using PostgreSQL as the main database since our launch in 2013 - and since then have encountered many smaller problems that we've had to deal with as we've grown, as well as making sure we get close to 100% uptime on our Postgres DB. This session is about the lessons learned, and will go into issues like: Exclusive locks held during DB schema changes, making zero downtime schema changes, choosing what to index, problems encountered with Ruby on Rails and its use of prepared statements, and more.

30 min
PGConf US 2016 [PgConf.US]
Use Cases