Re: Statistics updates is delayed when using `commit and chain` - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: Statistics updates is delayed when using `commit and chain`
Date
Msg-id CAKFQuwZSi6vWEUtZKQhqzHj8FeWtgon=HJ-BGLfpRwjErpwKGw@mail.gmail.com
Whole thread Raw
In response to Re: Statistics updates is delayed when using `commit and chain`  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Statistics updates is delayed when using `commit and chain`
List pgsql-bugs
On Tue, Jul 13, 2021 at 9:02 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
We are already doing that now, though I argue we are in fact documenting the "other clients receive the notification as soon as committed - regardless of chaining" situation (the additional restrictions on receiving are then what cause the chain authoring client to wait).


Specifically:

Firstly, if a NOTIFY is executed inside a transaction, the notify events are not delivered until and unless the transaction is committed.

vs.

So notification events are only delivered between transactions.

I'll accept that "and-chain" means there is no "between transactions" period.  But there is no qualification to "until the transaction is committed".

David J.

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Statistics updates is delayed when using `commit and chain`
Next
From: Japin Li
Date:
Subject: Re: Statistics updates is delayed when using `commit and chain`