Re: Postgres Stale Statistics

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Postgres Stale Statistics
Дата
Msg-id CAMkU=1x08AuiX4-7i76uofCJuiosFt0G8Q96+zv=EetyQr77cw@mail.gmail.com
обсуждение исходный текст
Ответ на Postgres Stale Statistics  (Nikhil Shetty <nikhil.dba04@gmail.com>)
Список pgsql-admin
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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Bakcup macro
Следующее
От: Pepe TD Vo
Дата:
Сообщение: Re: Bakcup macro