Breakout Session Presented by Dan Robinson of Heap at PGConf Silicon Valley 2015
14,300 views
About this video
Advanced · Hand-picked by a BrighterTube curator · found via HackerTube (Karpathy's dataset of videos Hacker News recommendsHeap'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