On Friday, November 27, 2020, Gustavsson Mikael <
mikael.gustavsson@smhi.se> wrote:
Hi.
After applying the latest patch we have encountered a problem with the pg_notify queue.
The queue is filling up and starts issuing warnings like
WARNING: NOTIFY queue is 87% full
DETAIL: The server process with PID 2969993 is among those with the oldest transactions.
NOTIFY queue cannot be emptied until that process ends its current transaction.
There is no long-running 'active' or 'idle in transaction' transactions on the server.
As its easy enough to run can you please confirm this by showing us the pg_stat_activity record for that pid during the time when this warning appears?
Thanks!
David J.