Citus Data Blog company blog
Postgres Count Performance
Everybody counts, but not always quickly. This post looks into how the PostgreSQL database optimizes counting. In Postgres, there are ways to count orders of magnitude faster. We’ll look at exact counts (distinct counts) as well as estimated counts, using approximation algorithms such as HyperLogLog (HLL) in Postgres.
- Points
- 153
- HN comments
- 31
- Submissions
- 1
- Cited by
- 4 commenters
Databases & DataSoftware Engineering2016
On Hacker News
| Submitted | Title on HN | Points | Comments |
|---|---|---|---|
| Oct 18, 2016 | Postgres Count Performance by rdegges | 153 | 31 |
Cited in comments
Linked from 4 Hacker News comments by 4 different people, from Apr 2019 to May 2022.
Most recent:
- inferiorhuman · May 28, 2022
- cube2222 · Jan 19, 2022
- rattray · Apr 6, 2021
- shay_ker · Apr 11, 2019
