public inbox for [email protected]
help / color / mirror / Atom feedFrom: Nathan Bossart <[email protected]>
To: Fujii Masao <[email protected]>
Cc: wenhui qiu <[email protected]>
Cc: Shinya Kato <[email protected]>
Cc: [email protected]
Subject: Re: enhance wraparound warnings
Date: Fri, 19 Jun 2026 13:43:22 -0500
Message-ID: <ajWNyueXTwLARwj5@nathan> (raw)
In-Reply-To: <CAHGQGwHWZTsR6bjdfpa+pOkBPjoXXm2LuJ+5nh+CvdyqEASHcQ@mail.gmail.com>
References: <aRdhSSFb9zZH_0zc@nathan>
<CAOzEurR9vD9kZ7=LAYqTDRju8wvCyvyEeiEtJVHJ_C6wH1u_MA@mail.gmail.com>
<aadFHfocomG20wgM@nathan>
<aatR8GUfwWA7ciFV@nathan>
<CAGjGUALHrAWK4jDK9xvwBHg-5Qw9bZF9yqNHHAXcVQrce8KJtw@mail.gmail.com>
<ab2dGqvlPLoihxBK@nathan>
<CAHGQGwHWZTsR6bjdfpa+pOkBPjoXXm2LuJ+5nh+CvdyqEASHcQ@mail.gmail.com>
On Sat, Jun 20, 2026 at 03:13:23AM +0900, Fujii Masao wrote:
> The percentage is calculated as (xidWrapLimit - xid) divided by half
> of the ID space. This represents the remaining ID space before wraparound,
> not the percentage of IDs that are still available for use. Since
> PostgreSQL stops assigning new XIDs/MultiXactIds at the stop limit
> before reaching the wraparound limit, the current wording could be
> interpreted as overstating how many IDs remain usable.
>
> So, how about changing the wording to match the calculation? For example:
>
> Approximately XX.XX% of transaction ID space remains before wraparound.
>
> and similarly for MultiXactIds.
That seems reasonable to me, thanks.
--
nathan
view thread (20+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: enhance wraparound warnings
In-Reply-To: <ajWNyueXTwLARwj5@nathan>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox