Conference Schedule - PGDay.EU 2010

Back

Windows that Work: How to use complex SQL for the greater good

Date: Dec. 7, 2010
Time: 13:10 - 14:00
Room: Tara

Window functions are very useful because they provide answers to questions commonly arising in real-world use cases. Indeed, prior to version 8.4, lots of people (including me) used to solve the same problems by writing custom stored procedures. The program for this talk is to walk through some specific examples of different sizes, to (1) show the capabilities of window functions, (2) explain their advantages over procedural solutions, and (3) discuss why people should invest resources in upgrading some of their queries so that they use window functions. The talk will include benchmarks on sufficiently large datasets, plus version-awareness of the various features.

Speaker

Gianni Ciolli

Privacy Policy | About the website
Copyright © 2008-2013 PostgreSQL Europe