ParadeDB tackles Postgres’ COUNT performance with ctid-aware segment partitioning, an inverted DocId map, and bitmap postings, accelerating Wikipedia COUNT queries. It also reports 10–22x TIN’s throughput on filtered and time-sorted Hacker News search queries.