Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Scalable incremental data aggregation on Postgres and Citus.
> We tested this approach for a CDN use case and found that a 4-node Citus database cluster can simultaneously:
> - Ingest and aggregate over a million rows per second
> - Keep the rollup table up-to-date within ~10s
> - Answer analytical queries in under 10ms.
There are no comments on this comment yet.
> We tested this approach for a CDN use case and found that a 4-node Citus database cluster can simultaneously:
> - Ingest and aggregate over a million rows per second
> - Keep the rollup table up-to-date within ~10s
> - Answer analytical queries in under 10ms.