| From: | Laetitia Avrot <laetitia(dot)avrot(at)gmail(dot)com> |
|---|---|
| To: | Japin Li <japinli(at)hotmail(dot)com> |
| Cc: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, John Naylor <john(dot)naylor(at)enterprisedb(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Statistics updates is delayed when using `commit and chain` |
| Date: | 2022-05-14 15:11:33 |
| Message-ID: | CAB_COdiHgHsUb7qxftTe9S-fagXr3Xv+Grw5rcdjwvu2pYy1uA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Hello,
Le mar. 27 juil. 2021 à 04:28, Japin Li <japinli(at)hotmail(dot)com> a écrit :
>
> I didn't find a SQL standard about `and chain`. IMO, whether the answer is
> "yes" or "no", we should update the statistics. For notify, however, I'm
> not
> sure.
>
>
Please find enclosed a new patch.
This patch includes the update of the statistics in case of commit and
chain.
This patch does not notify in case of commit and chain. Notify will only be
triggered should a proper commit be called. I updated the documentation to
explain that behavior.
The patch has been compiled and tested successfully on the latest master
branch.
Have a great day,
Lætitia
| Attachment | Content-Type | Size |
|---|---|---|
| v3-0001-update-table-stats-after-commit-and-chain.patch | application/octet-stream | 5.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PG Bug reporting form | 2022-05-15 02:37:22 | BUG #17481: sometime pg_stat_statements coredump |
| Previous Message | Andrey Lepikhov | 2022-05-13 06:56:43 | Negative value of numGroups |