Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Ask HN: What database should I use for analytics data?.
If PG is currently working for you, then chances are it'll keep working if you optimise it (partitioning, clustering, etc).
If you do want something else, the particular use cases you described are pretty much exactly what Clickhouse was built for.
There are no comments on this comment yet.
If PG is currently working for you, then chances are it'll keep working if you optimise it (partitioning, clustering, etc).
If you do want something else, the particular use cases you described are pretty much exactly what Clickhouse was built for.