ClickHouse: когда PostgreSQL уже не справляется

🎯 Watch unique videos and support the project: https://boosty.to/nikolay-pavlin 🔍 My book on the best practices of Python development: https://t.me/pavlin_share/176 📢 Suggest an idea for a future video - https://feedback.yapa.one 🚀 FastAPI template for a quick start: https://t.me/pavlin_share/179 🔔 Follow the news updates in TG: https://t.me/pavlin_share ClickHouse dramatically speeds up analytical queries compared to traditional DBMS. In this video, I will show the full work cycle: from theory to production deployment. Link to the project - https://github.com/Afaneor/clickhouse... 0:00 Intro 0:56 Columnar databases 6:40 Benchmark 9:12 How to get clickhouse up and running 10:09 Postgres vs Clickhouse 13:35 Clickhouse engines 15:18 Summing merge tree 18:20 Replacing merge tree 19:55 Asynchronous insert 20:33 Clickhouse python 22:57 Clickhouse django 24:34 Fixed length string 25:53 low cardinality 26:52 bloom filter 28:49 Data loading options