Conference Schedule - PGConf.EU 2011
Look Out The Window Functions (and free your SQL)
Window functions provide answers to common questions from real-world use cases, so they are gaining currency among application developers. Prior to their introduction in PostgreSQL 8.4, lots of people (including me) used to solve that kind of problems in a less efficient way by writing equivalent algorithms in imperative languages.
In this talk we will walk through some minimal examples to show the capabilities of window functions, explain their advantages over imperative solutions, and summarize the reasons why people should invest resources in upgrading some of their queries to window functions.
The talk will also include benchmarks on larger datasets, version-awareness of the various features, and how well (or badly) do window functions relate with other PostgreSQL features.