Writing

`VACUUM` reclaims dead-tuple space but doesn't shrink a table. PostgreSQL 19 Beta 2 adds an in-core online rewrite with REPACK (CONCURRENTLY), and much more.

What happens to old row versions after nobody needs them? They become dead tuples, and over time they bloat your tables. Go deeper into PostgreSQL MVCC with runnable psql examples.

with Jan Nidzwetzki, Etienne Berube

On gratitude, pressure, and the people who shaped my growth

On starting, and why half the battle is just showing up.