Skip to content

Breakout Session Presented by Dan Robinson of Heap at PGConf Silicon Valley 2015

Citus Data2.91K subscribers

14,300 views

About this video

Advanced · Hand-picked by a BrighterTube curator · found via HackerTube (Karpathy's dataset of videos Hacker News recommends

Heap's CTO explains how they store tens of billions of analytics events in PostgreSQL sharded with Citus, using arrays and partial indexes to answer funnel and cohort queries fast; real production numbers and schema decisions.

How Heap uses PostgreSQL at scale: partial indexes, JSON columns and query patterns for analytics data.

Video by Citus Data, played through YouTube's embedded player.

Part of PGConf Silicon Valley 2015