Postgres 18: Better Autovacuum and Incremental Backups for Ops

Why Postgres 18 matters for DevOps

Postgres 18 is the most operations-focused release in years, with changes that reduce daily toil for the teams running it in production.

Autovacuum improvements

The VACUUM machinery now pauses cleanly and reports progress on stuck indexes, which removes a whole class of "why is my table bloat growing" night calls.

Incremental backup support

pg_basebackup can now reuse prior backups, cutting the size and time of full backups dramatically for large clusters.

For platform teams

1. Upgrade the minor version in staging first
2. Enable new reporting views for vacuum and WAL activity
3. Test restore from the new incremental backup format

Backups you never run are better than backup software you never tested.

pg_basebackup -D /backup/full --format=t --incremental=/backup/base

Cutting backup time and vacuum dread is a quiet win that keeps teams from paging at 3am.