Practical Lessons Learned when using PostgreSQL at a Web Startup

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.
Length: 45:39
Views 159 Likes: 2
abstract
Recorded on 2016-04-18 at PGConf US
Look for other videos at PGConf US.
Tweet this video