Pavel Luzanov: PostgreSQL 19: part 5.2 (DBA1 and DBA2) of CommitFest 2026-03

2026-10-16来源 Planet PostgreSQLEnglish

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

...

原文：https://www.a8q9.cn/en/article/pavel-luzanov-postgresql-19-part-5-2-dba1-and-dba2-of-commitfest-2026-03-a1380d.html

相关文章