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

From Tom Lane
Subject Re: Statistics updates is delayed when using `commit and chain`
Date
Msg-id 2950681.1626103840@sss.pgh.pa.us
Whole thread Raw
In response to Statistics updates is delayed when using `commit and chain`  (Lætitia Avrot <laetitia.avrot@gmail.com>)
Responses Re: Statistics updates is delayed when using `commit and chain`
List pgsql-bugs
John Naylor <john.naylor@enterprisedb.com> writes:
> I understand this functionality to be tracking what happens at the physical
> level, in which case it is correct. In any case, the bug reported is clear
> and changing that behavior is the focus here. About the patch:

I do not think this is a bug at all.  The behavior is, and always has
been, that we report stats when we are about to wait for client input
and are not inside a transaction.  Likewise for NOTIFY.  The proposed
patch randomly changes that in a way that is very likely to break
clients.

Maybe you can persuade me that there's a reason to move the responsibility
for stats reporting to some other place, but please keep your hands
OFF of NOTIFY.  You clearly haven't the faintest idea what the client
contract for that is.

            regards, tom lane



pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #17101: Inconsistent behaviour when querying with anonymous composite types
Next
From: Tom Lane
Date:
Subject: Re: BUG #17100: undefined reference to `pg_qsort and pq_xxx