pgsql: Add percentage of available IDs to wraparound warnings.

From: Nathan Bossart <nathan(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add percentage of available IDs to wraparound warnings.
Date: 2026-03-20 19:16:30
Message-ID: E1w3fKf-000gcR-1Q@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add percentage of available IDs to wraparound warnings.

This commit adds DETAIL messages to the existing wraparound
WARNINGs that include the percentage of transaction/multixact IDs
that remain available for use. The hope is that this more clearly
expresses the urgency of the situation.

Reviewed-by: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>
Reviewed-by: Shinya Kato <shinya11(dot)kato(at)gmail(dot)com>
Reviewed-by: wenhui qiu <qiuwenhuifx(at)gmail(dot)com>
Discussion: https://postgr.es/m/aRdhSSFb9zZH_0zc%40nathan

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/e646450e609d690ced30d9e8e3fdc27ee6c3ff4c

Modified Files
--------------
doc/src/sgml/maintenance.sgml | 1 +
src/backend/access/transam/multixact.c | 8 ++++++++
src/backend/access/transam/varsup.c | 8 ++++++++
3 files changed, 17 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Andrew Dunstan 2026-03-20 19:32:10 pgsql: pg_waldump: Preparatory refactoring for tar archive WAL decoding
Previous Message Tom Lane 2026-03-20 18:51:02 pgsql: Discount the metapage when estimating number of index pages visi