Thread: 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.
Any help will be appreciated.
Thanks.
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:
Any help will be appreciated.Thanks.Hello list:Today I started to see this messages on the PostgreSQL log:2012-04-18 00:01:05 UTC : @ :WARNING: 01000: pgstat wait timeout2012-04-18 00:01:05 UTC : @ :LOCATION: backend_read_statsfile, pgstat.c:3807I 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.
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