Postgres Stale Statistics

Поиск
Список
Период
Сортировка
От Nikhil Shetty
Тема Postgres Stale Statistics
Дата
Msg-id CAFpL5VzjDi35wo3+P19+kc7wGPh5=Xc-kCUfNDoTg3xNrcHnCw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Postgres Stale Statistics  (Adelino Silva <adelino.silva@pt.ibm.com>)
Re: Postgres Stale Statistics  (Jeff Janes <jeff.janes@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: CTEs and temp_buffers?
Следующее
От: Adelino Silva
Дата:
Сообщение: Re: Postgres Stale Statistics