Effective Use of ClickHouse

on YouTube ↗59m

" summary

Covers practical experience using the open-source columnar database ClickHouse in production, naming ClickHouse as the technology. Describes common usage mistakes that harm performance and explains, with real-world examples, how different data schema and processing choices can change query performance by orders of magnitude.

AI-written summary · about

" chapters (8)

1. 0:00Introduction
2. 1:34Small insert problems
3. 12:27Data typing and performance
4. 27:24Long string storage optimization
5. 32:50ClickHouse anti-patterns
6. 40:56Load management and quotas
7. 46:15Updates and data refresh
8. 51:57Q&A

" related talks

• 51mTheory and practice of using ClickHouse in real applicationsAleksandr Zaytsev · Backend Conf 2018
• 44mUnconventional Uses of ClickHouseAleksandr Zaytsev · HighLoad++ Moscow 2018
• 51mWhat You Need to Know About ClickHouse ArchitectureAleksey Zatelepin · РИТ++ 2017
• 53mClickHouse Is Slowing DownKirill Shvakov · HighLoad++ Moscow 2018
• 49mSolving real business cases with ClickHouseDmitriy Cherobaev · Saint HighLoad++ 2025
• 42mClickHouse: what is behind the fastest columnar databaseOlena Kutsenko · Berlin Buzzwords 2023
• 34mClickHouse® - What is Behind the Fastest Columnar Database?Olena Kutsenko · OSA Con 2022
• 42mOptimizing ClickHouse query performanceMaksim Kita · Saint HighLoad++ 2022