Thread: pgstat wait timeout

pgstat wait timeout

From
Efraín Déctor
Date:
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?.
 
 
Thank you.

Re: pgstat wait timeout

From
Efraín Déctor
Date:
Any help will be appreciated.
 
Thanks.
 
Sent: Wednesday, April 18, 2012 1:32 PM
Subject: pgstat wait timeout
 
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?.
 
 
Thank you.

Re: pgstat wait timeout

From
tuanhoanganh
Date:
I have same problem too.

Tuan Hoang Anh

On Thu, Apr 19, 2012 at 10:43 PM, Efraín Déctor <efraindector@motumweb.com> wrote:
Any help will be appreciated.
 
Thanks.
 
Sent: Wednesday, April 18, 2012 1:32 PM
Subject: pgstat wait timeout
 
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?.
 
 
Thank you.

Re: pgstat wait timeout

From
Fujii Masao
Date:
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