Re: 20.5.1 - Mailing list pgsql-docs

From Laurenz Albe
Subject Re: 20.5.1
Date
Msg-id b617da05e12053585a07bd3bbd1ef2bcb973e8ff.camel@cybertec.at
Whole thread Raw
In response to Re: 20.5.1  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-docs
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



pgsql-docs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: 20.5.1
Next
From: PG Doc comments form
Date:
Subject: Pathetic pedantry