Get the latest tech news

Solving Postgres' Count Problem


How ctid-aware segment partitioning, an inverted DocId map, and bitmap postings accelerated ParadeDB's Wikipedia COUNT queries—then a look at the rest of search, where ParadeDB delivered 10–22x TIN's throughput on filtered and time-sorted Hacker News queries.

None

Get the Android app

Or read this on Hacker News

Read more on:

Photo of Postgres

Postgres

Photo of Count Problem

Count Problem

Related news:

News photo

Built to bend: Postgres’s inventor and a steward on what AI really needs

News photo

Postgres recovery_prefetch can cause outages

News photo

Postgres 19 delayed after AI reviewers find more bugs than humans can fix