Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only! Grab it Explore how PostgreSQL aggregates function internally and learn to create and utilize custom aggregates effectively in this conference talk from PGConf NYC 2021. Gain insights into transition, final, and combine functions, parallel aggregation, and aggregate de-duplication and optimization through visual explanations. Discover the power of custom aggregates and their implementation in various programming languages. Understand the design principles for efficient custom aggregates, including the two-step design pattern used in TimescaleDB hyperfunctions. Learn how to leverage these concepts to optimize your PostgreSQL applications and enhance database performance.