Schedule - PGConf.EU 2012

Debugging complex SQL queries with writable CTEs

Date: 2012-10-26
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

Gold Sponsors

Silver Sponsors

---

Related Conferences