Postgres Stale Statistics - Mailing list pgsql-admin

From Nikhil Shetty
Subject Postgres Stale Statistics
Date
Msg-id CAFpL5VzjDi35wo3+P19+kc7wGPh5=Xc-kCUfNDoTg3xNrcHnCw@mail.gmail.com
Whole thread Raw
Responses Re: Postgres Stale Statistics  (Adelino Silva <adelino.silva@pt.ibm.com>)
Re: Postgres Stale Statistics  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-admin
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? We are thinking of building the standby again but what if the WARNING is for a primary database instance and a restart won't solve it?


Thanks and Regards,

Nikhil

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: CTEs and temp_buffers?
Next
From: Adelino Silva
Date:
Subject: Re: Postgres Stale Statistics