Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres Stale Statistics - Mailing list pgsql-admin

From Jeff Janes
Subject Re: Postgres Stale Statistics
Date
Msg-id CAMkU=1x08AuiX4-7i76uofCJuiosFt0G8Q96+zv=EetyQr77cw@mail.gmail.com
Whole thread Raw
In response to Postgres Stale Statistics  (Nikhil Shetty <nikhil.dba04@gmail.com>)
List pgsql-admin
Tree view
On Wed, Apr 27, 2022 at 7:09 AM Nikhil Shetty <nikhil.dba04@gmail.com> wrote:
Hi,

We are getting below WARNING on one of the standby instances. Not sure what caused it but to resolve it we tried restarting the database instances but it is still not working


WARNING - using stale statistics instead of current ones because stats collector is not responding


Postgresql version - 11.7


Any other option to resolve this?


If it is always present (not just when IO is overwhelmed) maybe it has an internal firewall blocking UDP on 127.0.0.1.

Cheers,

Jeff

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Bakcup macro
Next
From: Pepe TD Vo
Date:
Subject: Re: Bakcup macro