UUIDv4 vs UUIDv7: What a Random Primary Key Costs — The difference is minimal if the index fits in memory, but grows rapidly as it outgrows the cache! In a memory-constrained benchmark, UUIDv4 inserts ran at two-thirds the rate of an ordered key and generated more WAL. Nikolay explains why and shares some catches in switching to uuidv7().

Nikolay Samokhvalov (PostgresAI)

Your Retention Job Shouldn’t Be a Four-Hour DELETE — Purging old rows with DELETE bloats the table, hammers WAL, and leaves VACUUM behind. TimescaleDB partitions by time, so retention drops whole chunks in milliseconds. Same Postgres, same SQL. Start on Tiger Cloud with a $1000 credit.

Tiger Data (creators of TimescaleDB) sponsor

Is Postgres Really Winning? — Postgres is the only top four database gaining ground in the DB-Engines rankings and might pass SQL Server soon, but it measures 'popularity', not production use. In part two, Dave looks further afield, at developer surveys, acquisitions, and what AI tools reach for by default. In short, things continue to look bright for Postgres.

Dave Stokes

Why VACUUM Doesn't Shrink Your Postgres Indexes — A page-by-page look, using pageinspect, at why VACUUM thins out B-tree index pages but can't shrink the index, and why sequential keys don't refill the gaps. There's also an interactive visualizer to try it on a tiny tree yourself.

Radim Marek

An Index Scan Is Only Half the Story: How On-Disk Ordering Affects Performance — A look at why an identical index scan can become far slower after a migration involving a parallel data load. Richard shares a ctid query to help detect the problem.

Richard Yen

What Postgres is Waiting For (and Why Dashboards Can't Tell You) — Wait event dashboards work by sampling, so they can be right about where time goes overall, yet wrong about why one request is slow.

Dmitry Fomin (PostgresAI)

Don't Dream It, Be It! — Slonik, Postgres's mascot, turns up at many Postgres events, but who's in the suit? At last month's PGConf.EU it was Laurenz Albe, who reports that it's hot, you can't see your feet, but everybody wants a photo. His advice to first-time attendees who don't know anyone is… volunteer!

Laurenz Albe (CYBERTEC)