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

Schedule - Nordic PGDay 2015

Fixing Nightmare Queries

Date: 2015-03-11
Time: 13:30–14:20
Room: Falconer 202-203

Every "optimizing query" tutorial shows lots of examples of how very small queries can be repaired. But real-life bad queries are often much, much more complex. How do you even begin with a query that contains five CTEs (one with a recursive CTE inside of it), a join against a set-returning function, and a custom operator?

We'll talk about approaches you can take to restructure, tweak and refactor these monstrous queries to get better (if not great) results out of them.


Christophe Pettus