undefined | Better HN

0 pointsosigurdson29d ago0 comments

From experience, I'd suggest using ClickHouse beyond a few billion rows of timeseries data in Postgres.

0 comments

2 comments · 1 top-level

throwaway778329d ago· 1 in thread

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

osigurdsonOP29d ago

ClickHouse is fine for looking at recent data (with simple / efficient TTL). I'd still (probably) use Postgres for smaller scale things however.

j / k navigate · click thread line to collapse