PostgreSQL Aggregate and Window Function Tuning

If you have ever watched a dashboard query get slower as the customer table grew, or seen a percentile_cont call suddenly spill 12 MB of temp files to disk, this article is for you. Aggregates and window functions are two of the highest-leverage area...