Hacker News new | ask | show | jobs
by osigurdson 25 days ago
From experience, I'd suggest using ClickHouse beyond a few billion rows of timeseries data in Postgres.
1 comments

Nice thing about our use case is that its not strictly analytics, but looking at most recent raw data. ClickHouse is definitely the powerhouse for analytics
ClickHouse is fine for looking at recent data (with simple / efficient TTL). I'd still (probably) use Postgres for smaller scale things however.