PostgreSQL Aggregate and Window Function Tuning

GROUP BY and window functions look declarative — the query says what it wants, and PostgreSQL figures...