On Friday, November 27, 2020, Gustavsson Mikael <mikael.gustavs...@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.
