Postgres

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.

Blog post · Databases · Performance · Open Source · Postgres

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.

Blog post · Databases · Postgres · Performance · Engineering

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.

Blog post · Postgres · Kafka · Engineering · Performance