s is useful for someone else. Thanks again for your help
Tom - your advice on listen/notify locking on commit was very useful
despite not being the cause in this case.
Cheers
Ben
On Mon, 1 Feb 2021 at 12:33, Ben Hoskings wrote:
>
> On Mon, 1 Feb 2021 at 10:33, Tom Lane wrote:
> &
On Mon, 1 Feb 2021 at 10:33, Tom Lane wrote:
>
> One thing that just occurred to me is that you might find it
> interesting to keep tabs on what's in the $PGDATA/pg_notify
> directory. Do the performance burps correspond to transitory
> peaks in the amount of data there? Or (grasping at straws h
On Sun, 31 Jan 2021 at 03:50, Tom Lane wrote:
>
> Possibly you'd benefit from updating to v13, which has the listen/notify
> performance improvements Martijn referred to in the other thread.
>
> It's also possible that the hangup is unrelated to that, being somewhere
> later in commit processing t
messages on commit:
https://www.postgresql.org/message-id/3598.1363354686%40sss.pgh.pa.us
If that's the case, the real question is why a small number of those
commits are taking so much longer than expected. Any advice on how to
proceed from here much appreciated.
Cheers
Ben Hoskings
---
The observed outage
