the talk covers PostgreSQL grouping and aggregation facilities and best practices of using them in fast and efficient manner. In 40 minutes the audience will learn several techniques to optimise queries containing GROUP BY,