| From: | Nathan Bossart <nathandbossart(at)gmail(dot)com> |
|---|---|
| To: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com> |
| Cc: | wenhui qiu <qiuwenhuifx(at)gmail(dot)com>, Shinya Kato <shinya11(dot)kato(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: enhance wraparound warnings |
| Date: | 2026-06-19 18:43:22 |
| Message-ID: | ajWNyueXTwLARwj5@nathan |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dinesh salve | 2026-06-19 19:04:43 | Re: explain plans for foreign servers |
| Previous Message | Jeff Davis | 2026-06-19 18:40:34 | Re: Bug in ALTER SUBSCRIPTION ... SERVER / ... CONNECTION with broken old server |