ClickHouse Is Slowing Down

on YouTube ↗53m

" summary

A practical guide showing how to build inefficient solutions with the ClickHouse columnar database. It demonstrates specific anti-patterns and mistakes when using ClickHouse that cause slowdowns and poor performance, aimed at developers of high-load systems.

AI-written summary · about

" chapters (8)

1. 0:00Introduction
2. 6:31Old system problems
3. 11:50Switching to ClickHouse
4. 19:13Data write issues
5. 27:18Index optimization
6. 34:01Array memory problem
7. 38:12Final improvements
8. 43:52Q&A

" related talks

• 59mEffective Use of ClickHouseAleksey Milovidov · HighLoad++ 2017
• 51mWhat You Need to Know About ClickHouse ArchitectureAleksey Zatelepin · РИТ++ 2017
• 42mClickHouse: what is behind the fastest columnar databaseOlena Kutsenko · Berlin Buzzwords 2023
• 49mSolving real business cases with ClickHouseDmitriy Cherobaev · Saint HighLoad++ 2025
• 34mClickHouse® - What is Behind the Fastest Columnar Database?Olena Kutsenko · OSA Con 2022
• 47mClickHouse Without Pain: Our Experience Refactoring a Legacy Cluster and the Impact of Shard GroupsM.Filimonov · Saint HighLoad++ 2025
• 51mTheory and practice of using ClickHouse in real applicationsAleksandr Zaytsev · Backend Conf 2018
• 42mOptimizing ClickHouse query performanceMaksim Kita · Saint HighLoad++ 2022