pgstat wait timeout

Any help will be appreciated.

Thanks.

From: Efraín Déctor
Sent: Wednesday, April 18, 2012 1:32 PM
To: pgsql-general@postgresql.org
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.

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:

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