pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feed20.5.1
3+ messages / 3 participants
[nested] [flat]
* 20.5.1
@ 2024-02-07 16:05 PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 3+ messages in thread
From: PG Doc comments form @ 2024-02-07 16:05 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: aarnott@hotmail.com
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: 20.5.1
@ 2024-02-07 16:59 David G. Johnston <david.g.johnston@gmail.com>
parent: PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 3+ messages in thread
From: David G. Johnston @ 2024-02-07 16:59 UTC (permalink / raw)
To: aarnott@hotmail.com <aarnott@hotmail.com>; pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
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”.
Maybe phrasing it in the negative will make things clear - the more
required sessions needed before allowing a delay the less likely the delay
will be wasted.
David J.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: 20.5.1
@ 2024-02-07 20:10 Laurenz Albe <laurenz.albe@cybertec.at>
parent: David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Laurenz Albe @ 2024-02-07 20:10 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; aarnott@hotmail.com <aarnott@hotmail.com>; pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-02-07 20:10 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-02-07 16:05 20.5.1 PG Doc comments form <noreply@postgresql.org>
2024-02-07 16:59 ` David G. Johnston <david.g.johnston@gmail.com>
2024-02-07 20:10 ` Laurenz Albe <laurenz.albe@cybertec.at>
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