Conference Schedule - PGConf.EU 2012

Back

Debugging complex SQL queries with writable CTEs

Date: Oct. 26, 2012
Time: 11:50 - 12:40
Room: Thames
Level: Beginner

Sometimes you have a complex query using subqueries, and even using EXPLAIN output you still can't understand why the output differs from what you expected.

In this talk we show how CTE (a.k.a. WITH queries), more precisely the writable ones introduced in PostgreSQL 9.1, can provide a debugging and tracing tool.

We will provide concrete examples and try to point out pitfalls and limitations.

Speaker

Gianni Ciolli

Platinum Sponsors

2ndQuadrant EnterpriseDB

Gold Sponsors

VMware Servoy Cybertec

Silver Sponsors

pgPower Dalibo GoodData Heroku


Related Conferences

Postgres Open 2012