Heap's PostgreSQL Analytics Backend at 50 TB

HN commenters point to it as a first-hand overview of Heap's Postgres/Citus architecture and its distinctive indexing approach.

Dan Robinson, then CTO of Heap, explains how Heap runs its product analytics backend on PostgreSQL and CitusDB. It covers conversion funnels, retention and cohort queries across tens of billions of events and 50 TB of data, plus Postgres and Kafka together and the indexing strategy.