In-depth: ClickHouse vs PostgreSQL
Written version of this video - https://posthog.com/blog/clickhouse-v...
Subscribe for more - https://www.youtube.com/@PostHog?sub_...
Get signup for PostHog for free - https://app.posthog.com/signup
More content like this - https://posthog.com/blog
Follow us on Twitter - / posthog
In this video, we compare ClickHouse vs PostgreSQL.
0:00 Intro
0:50 Database types: OLTP vs OLAP
1:53 Example use cases
3:50 ClickHouse scales better
4:21 Materialize views
5:08 Engines
5:45 Postgres sharding
6:34 Outro