Loading…
Postgres Build 2021 has ended
Back To Schedule
Wednesday, December 1 • 10:15am - 10:55am
How PostgreSQL aggregates work (through pictures) and how to create and use custom aggregates

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Aggregates are one of the most commonly used features of PostgreSQL, but many people don’t understand how they work. This talk will provide a brief overview of how aggregates work in PostgreSQL through pictures including:
-Transition, final and combine functions
-Parallel aggregation
-Aggregate de-duplication and optimization

Then we will go over how you can use this knowledge to construct custom aggregates for use in your applications, with examples of how to design custom aggregates to fill specific needs and work efficiently.

Speakers
avatar for David Kohn

David Kohn

Software Engineer, Timescale
David Kohn is a Software Engineer at Timescale. He started out as an electrochemist and fell into databases over 5 years ago, since then he’s worked almost exclusively on PostgreSQL. He has helped design applications and tools for very high volume, multi-terabyte installations... Read More →


Wednesday December 1, 2021 10:15am - 10:55am GMT