| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | John Naylor <john(dot)naylor(at)enterprisedb(dot)com> |
| Cc: | Japin Li <japinli(at)hotmail(dot)com>, Lætitia Avrot <laetitia(dot)avrot(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Statistics updates is delayed when using `commit and chain` |
| Date: | 2021-07-12 15:30:40 |
| Message-ID: | 2950681.1626103840@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
John Naylor <john(dot)naylor(at)enterprisedb(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2021-07-12 15:57:18 | Re: BUG #17100: undefined reference to `pg_qsort and pq_xxx |
| Previous Message | Tom Lane | 2021-07-12 15:07:24 | Re: BUG #17101: Inconsistent behaviour when querying with anonymous composite types |