Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Nov 24, 2015
Powering Heap With PostgreSQL And CitusDB
At Heap, we lean on PostgreSQL for all our backend heavy lifting. We support an expressive set of queries — conversion funnels with filtering and grouping, retention analysis, and behavioral cohorting to name a few — across billions of users and tens of billions of events. Results need to come back in a matter of seconds and reflect up-to-the-minute data.
This talk will discuss these challenges, with a particular focus on: - Using CitusDB for interactive analysis across 50 terabytes of data and counting. - PostgreSQL and Kafka: two great tastes that taste great together. - UDFs in C and PL/pgSQL, partial indexes for pre-aggregation, and other tricks up our sleeves.