signal_tag · 2_broadcasts
#postgres
// 2 transmissions tagged with #postgres
TX_260900· Engineering
I built IndexPilot, a Postgres index checker, by accident
Jai Thakur’s side‑project turned into IndexPilot, a tool that evaluates proposed PostgreSQL indexes against query patterns, existing indexes, and optional hypothetical plans.
TX_022· Engineering
Postgres 18's async I/O subsystem hits 3x on sequential scans
Postgres 18 introduced an asynchronous I/O subsystem that issues parallel I/O requests instead of waiting on each one. Benchmarks show up to 3x gains on seq scans, bitmap heap scans, and vacuum.