| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com> |
| Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Postgres Stale Statistics |
| Date: | 2022-04-27 14:07:30 |
| Message-ID: | CAMkU=1x08AuiX4-7i76uofCJuiosFt0G8Q96+zv=EetyQr77cw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Wed, Apr 27, 2022 at 7:09 AM Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pepe TD Vo | 2022-04-27 14:15:36 | Re: Bakcup macro |
| Previous Message | Bruce Momjian | 2022-04-27 13:53:56 | Re: Bakcup macro |