Postgres Pro
Downloads
Home   >   mailing lists

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

From Laetitia Avrot
Subject Re: Statistics updates is delayed when using `commit and chain`
Date
Msg-id CAB_COdiHgHsUb7qxftTe9S-fagXr3Xv+Grw5rcdjwvu2pYy1uA@mail.gmail.com
Whole thread Raw
In response to Re: Statistics updates is delayed when using `commit and chain`  (Japin Li <japinli@hotmail.com>)
Responses Re: Statistics updates is delayed when using `commit and chain`
Re: Statistics updates is delayed when using `commit and chain`
List pgsql-bugs
Tree view
Hello,

Le mar. 27 juil. 2021 à 04:28, Japin Li <japinli@hotmail.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

pgsql-bugs by date:

Previous
From: Andrey Lepikhov
Date:
Subject: Negative value of numGroups
Next
From: PG Bug reporting form
Date:
Subject: BUG #17481: sometime pg_stat_statements coredump