Topic
Everything filed under Postgres, newest first.
RSS · JSON · All topics
Postgres 19 REPACK: Built-In Online Table Bloat Cleanup
Craig Kerstiens explains Postgres 19's new REPACK command and REPACK (CONCURRENTLY), which bring online table and index rebuilds into core, compares them with VACUUM FULL, CLUSTER and pg_repack, and shows how to use them to reclaim bloat without downtime.
9 min · 2,182 words
PlanetScale Released Text Search and We Have a Lot to Say (Part I)
Two BM25 optimizations and benchmark configuration changes inspired by PlanetScale's TIN benchmarks make ParadeDB's text search faster without changing its document identifiers.
14 min · 3,188 words
Postgres SELECT DISTINCT Does Not Scale
DBOS explains why Postgres SELECT DISTINCT can get surprisingly expensive as datasets grow, what the planner is doing, and how they mitigated it in practice.
5 min · 1,068 words
700 MB/s of Kafka throughput, on Postgres
Profiling Kafgres (Kafka-compatible broker inside Postgres) from ~113 MB/s to ~700 MB/s via cached SPI plans, relaxed commits, separate topic disks, and WaitEventSet socket readiness.
5 min · 1,062 words