# E182: The Rise of ClickHouse Page: https://stenobird.com/podcast/open-source-startup-podcast/e182-the-rise-of-clickhouse Text version: https://stenobird.com/podcast/open-source-startup-podcast/e182-the-rise-of-clickhouse.md Podcast: [Open Source Startup Podcast](https://stenobird.com/podcast/open-source-startup-podcast) Published: 2025-10-08T21:09:42+00:00 Episode link: https://podcasters.spotify.com/pod/show/ossstartuppodcast/episodes/E182-The-Rise-of-ClickHouse-e3992rl Audio file: https://anchor.fm/s/3eab794c/podcast/play/109398325/https%3A%2F%2Fd3ctxlq1ktw2nl.cloudfront.net%2Fstaging%2F2025-9-8%2F3d17188d-b4d6-93d3-1d9a-0e17d50e1cf5.mp3 Processing state: processed JSON: https://stenobird.com/v1/public/podcasts/open-source-startup-podcast/episodes/e182-the-rise-of-clickhouse Duration seconds: 2822 ## Resource ClickHouse evolved from a Yandex internal tool into a $6B+ powerhouse by leveraging columnar storage for massive-scale analytics. Co-founder Yury Izrailevsky explains how they scaled from open-source roots to a high-performance managed cloud service. ## Highlights - Main idea: ClickHouse uses columnar storage to achieve superior compression and execution speeds for large-scale analytical workloads - Practical takeaway: Achieving architectural parity between open-source and cloud versions prevents vendor lock-in and ensures consistent query results - Failure mode: Neglecting back-office operations like billing and CRM before launch can lead to significant operational friction during rapid growth - Strategic insight: Building a team of experienced, self-sufficient engineers is more effective for rapid innovation than hiring early-career talent - Operational lesson: Scaling a managed service requires having sales, marketing, and support functions ready before the product reaches GA ## Topics ClickHouse, OLAP Databases, Columnar Storage, Open Source Software, Cloud Computing, Data Warehousing, Real-time Analytics, AI Infrastructure ## Chapters - 1:00 — Origins at Yandex: The history of ClickHouse as an internal project for Yandex Metrica and its transition to open source. - 4:35 — The Performance Advantage: What makes ClickHouse stand out in the competitive landscape of analytical databases. - 8:05 — Columnar Architecture: A technical look at how columnar storage improves data compression and query efficiency. - 14:40 — Managing Rapid Innovation: The challenges of maintaining a monthly release cadence while ensuring commercial-grade stability. - 18:30 — Cloud Scalability: How the separation of compute and storage enables elastic scaling and cost-efficient idling in the cloud. - 25:25 — Building High-Velocity Teams: Strategies for recruiting the right talent to execute at a breakneck pace. - 32:30 — Modern Use Cases: AI and Observability: How industry leaders like OpenAI and Netflix use ClickHouse for massive-scale event processing. ## Actions - request_transcript: `POST https://stenobird.com/v1/public/podcasts/open-source-startup-podcast/episodes/e182-the-rise-of-clickhouse/transcription-requests` — Idempotently request low-priority transcript generation for this episode. - read_markdown: `GET https://stenobird.com/podcast/open-source-startup-podcast/e182-the-rise-of-clickhouse.md` — Read the agent-friendly Markdown representation of this episode resource. A page view does not enqueue transcription. Agents should invoke `request_transcript` explicitly when they need this episode processed. ## Transcript Full transcripts are not published on public pages unless there is a clear rights basis.