Planet PostgreSQL – Paul Ramsey: Fast, Flexible Summaries with Aggregate Filters and Windows

PostgreSQL can provide high performance summaries over multi-million record tables, and supports some great SQL sugar to make it concise and readable, in particular aggregate filtering, a feature unique to PostgreSQL and SQLite. 

A huge amount of reporting is about generating percentages: for a particular condition, what is a value relative to a baseline.

External feed Read More at the Source: https://postgr.es/p/59m