This site is about a previous instance of this event. For the current event, please see the updated site.

Conference Schedule - PGConf.EU 2017

Database Horror Stories, Bad Code, and How Not to be a Statistic

Date: 2017-10-25
Time: 09:45 - 10:45
Room: Baltic I
Level: Beginner

36,321 tables, one row each, one database. A stored procedure with 1,752 parameters. A DBA convinced that storing everything in the entire database typed as BYTEA will definitely improve performance. All of these are true stories, and the sad fact is that many PostgreSQL professionals can relate to them -- even if they won't admit it in public.

In this talk, I will discuss some of my favorite database anti-examples from The Daily WTF (including a particularly egregious one concocted by yours truly), and discuss how they came to be and where they came from. Most importantly, I'll cover how to avoid unintentionally creating your own database WTFs.

Slides

The following slides have been made available for this session:

Speaker

Alex Papadimoulis