Dev Tools · 1h ago
Postgres vs ClickHouse? Use both with one simple rule
An uptime monitor splits data: config and incidents in Postgres, check results in ClickHouse. The rule: if a row ever changes, use Postgres; if written once and never updated, use ClickHouse. This approach handles billions of rows cheaply with proper codecs, sort keys, and per-row TTL.
Meridian48 take
The article's pragmatic split rule is more useful than most database comparisons, but it glosses over operational complexity of running two databases in production.
Read the full reporting
Postgres vs ClickHouse? I use both. 4 tricks from the split. →
DEV Community
postgresclickhouse