Breakout Session Presented by Dan Robinson of Heap at PGConf Silicon Valley 2015
4 人推荐 · 跨 5 个月 · 2016–2020
中文导读
时任 Heap 首席技术官 Dan Robinson 深度分享 Heap 如何基于 PostgreSQL 与 CitusDB 构建其产品分析平台后端。实战复盘在数百亿事件量与 50TB 级数据规模下，如何高效支撑转化漏斗、用户留存与分群查询，并详述了 Postgres、Kafka 协作管线与定制索引策略。
为什么 HN 推它
HN 探讨海量数据分析架构时的必备参考，全方位展示了 Heap 极具参考价值的 Postgres/Citus 架构实践与独门索引设计。
「Heap Analytics 的 Dan 这场讲座太棒了，把 Postgres 和 Citus 的用法讲得极具实战参考价值。」HN 网友原话：Dan from Heap Analytics has a great talk about how they use Postgres and Citus.
英文原摘要（HackerTube / Claude 整理）
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.
HN commenters point to it as a first-hand overview of Heap's Postgres/Citus architecture and its distinctive indexing approach.
HN 上的提及
excellent talk from one of the Heap Analytics engineers
Dan from Heap Analytics has a great talk about how they use Postgres and Citus.
I like this[1] talk, it gives you an overview of their architecture.
a very specific indexing strategy (discussed about in a talk Dan gave[0])
our indexing strategy which Dan talks about in this talk[0]