Time: 13:10 - 14:00
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.