We’re continuing our review of the March CommitFest for PostgreSQL 19. This second article in the series covers the changes related to our DBA1 and DBA2 courses.

As a reminder, here’s the plan for our coverage of the final PostgreSQL 19 CommitFest:

Part 5.1 (QPT)

Part 5.2 (DBA1, DBA2) -- you are here 🙂

Part 5.3 (DBA3, DBS)

Part 5.4 (SQL, DEV1, DEV2)

For the earlier CommitFests, see: 2025-07, 2025-09, 2025-11, 2026-01.

Here’s what’s covered:

  • REPACK: rewriting a table to reclaim disk space
  • Autovacuum: table processing order
  • Autovacuum: parallel index vacuuming
  • Enhanced transaction ID wraparound warnings
  • Checkpoint reason in the completion log message
  • Less WAL and on-access visibility map updates
  • More code paths use read streams
  • pg_stat_lock: statistics on long lock waits
  • pg_upgrade: faster large object transfer, part 2
  • oid2name: file paths relative to PGDATA
  • psql: comments on internal queries
  • log_min_messages per backend type
  • Stats reset time for pg_stat_database_conflicts and pg_statio_all_sequences

...