From: Laurenz Albe <laurenz.albe@cybertec.at>
To: David G. Johnston <david.g.johnston@gmail.com>
To: aarnott@hotmail.com <aarnott@hotmail.com>
To: pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
Subject: Re: 20.5.1
Date: Wed, 07 Feb 2024 21:10:57 +0100
Message-ID: <b617da05e12053585a07bd3bbd1ef2bcb973e8ff.camel@cybertec.at> (raw)
In-Reply-To: <CAKFQuwYK=vBUwz71zrWQEpss99DdfVjWsCEiDurxYWJPqdsyqg@mail.gmail.com>
References: <170732194310.3279719.11926489697036463656@wrigleys.postgresql.org>
<CAKFQuwYK=vBUwz71zrWQEpss99DdfVjWsCEiDurxYWJPqdsyqg@mail.gmail.com>
On Wed, 2024-02-07 at 09:59 -0700, David G. Johnston wrote:
> On Wednesday, February 7, 2024, PG Doc comments form <noreply@postgresql.org> wrote:
> > The following documentation comment has been logged on the website:
> >
> > Page: https://www.postgresql.org/docs/16/runtime-config-wal.html
> > Description:
> >
> > The sentence in commit_siblings "A larger value makes it more probable that
> > at least one other transaction will become ready to commit during the delay
> > interval." seems to belong in commit_delay instead.
> >
>
> That sentence in that location is correct. See “birthday paradox”.
To be more precise: if 15 other transactions are currently running, there
is a bigger chance that at least one of them will want to flush WAL before
"commit_delay" has expired than if there are only 3 other transactions.
Yours,
Laurenz Albe
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: pgsql-docs@postgresql.org
Cc: laurenz.albe@cybertec.at, david.g.johnston@gmail.com, aarnott@hotmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: 20.5.1
In-Reply-To: <b617da05e12053585a07bd3bbd1ef2bcb973e8ff.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox