5 ms·
From experience, I'd suggest using ClickHouse beyond a few billion rows of timeseries data in Postgres.
by osigurdson 4mo ago
From experience, I'd suggest using ClickHouse beyond a few billion rows of timeseries data in Postgres.
- throwaway7783 4mo agoNice 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
- osigurdson 4mo agoClickHouse is fine for looking at recent data (with simple / efficient TTL). I'd still (probably) use Postgres for smaller scale things however.