Hi,
I am having a scenario where I get consistent warnings in the pglog folder:
2011-12-11 00:00:03 JST WARNING: pgstat wait timeout
2011-12-11 00:00:14 JST WARNING: pgstat wait timeout
2011-12-11 00:00:24 JST WARNING: pgstat wait timeout
2011-12-11 00:00:31 JST WARNING: pgstat wait timeout
2011-12-11 00:00:44 JST WARNING: pgstat wait timeout
2011-12-11 00:00:52 JST WARNING: pgstat wait timeout
2011-12-11 00:01:03 JST WARNING: pgstat wait timeout
2011-12-11 00:01:11 JST WARNING: pgstat wait timeout
.
.
.
This is impacting database performance.
The issue persists even when I use the database minimally.
I have tried fine-tuning the Auto-vacuum parameters:
Change the parameter autovacuum_vacuum_cost_delay to 40ms ::: Issue is
reproduced 4 hours after this change
Change the parameter autovacuum_max_workers to 20 ::: I got the warning
message 2 times at times 17:20:12 and 17:20:20. After this, no warnings for
5 hours. Then I tried:
Change the parameter autovacuum_vacuum_cost_delay to: 60ms, Change the
parameter autovacuum_max_workers to: 10::: I got the warning message 2 times
at times 17:20:12 and 17:20:20. After this, no warnings for 5 hours
Any Ideas?
--
View this message in context: http://postgresql.1045698.n5.nabble.com/pgstat-wait-timeout-tp5078125p5078125.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.
