Re: pgstat wait timeout - Mailing list pgsql-general

From Fujii Masao
Subject Re: pgstat wait timeout
Date
Msg-id CAHGQGwEmr6Lr_A9ek6PSygf9YOvHsggvoYc5dd4=0PsXb2QZWQ@mail.gmail.com
Whole thread Raw
In response to pgstat wait timeout  (Efraín Déctor <efraindector@motumweb.com>)
List pgsql-general
On Thu, Apr 19, 2012 at 3:32 AM, Efraín Déctor
<efraindector@motumweb.com> wrote:
> Hello list:
>
> Today I started to see this messages on the PostgreSQL log:
>
> 2012-04-18 00:01:05 UTC : @  :WARNING:  01000: pgstat wait timeout
> 2012-04-18 00:01:05 UTC : @  :LOCATION:  backend_read_statsfile,
> pgstat.c:3807
>
> I searched and to fix it it was recommended to disable autovacuum, I did it
> and it worked, but how can I fix it without disabling autovacuum?.

This might be alleviated by setting stats_temp_directory to point to a ramdisk.

Regards,

--
Fujii Masao

pgsql-general by date:

Previous
From: Vincenzo Romano
Date:
Subject: And what about temporary functions? (Was: How to drop a temporary view?)
Next
From: Tom Lane
Date:
Subject: Re: And what about temporary functions? (Was: How to drop a temporary view?)