While doing some pgbench testing on a new server with 9.1.1, I noticed
quite a lot of $subject in the logs. I did some Googling and found this
previous thread:
http://archives.postgresql.org/pgsql-hackers/2010-01/msg02897.php It
doesn't seem like the issue was resolved?
I did:
# pgbench -i -s 1000 bench1
# pgbench -c 8 -j 4 -T 1000 bench1
The server is:
PostgreSQL 9.1.1
Ubuntu 10.04 2.6.32-35-generic #78-Ubuntu SMP x86_64
Quad Core Xeon, 22GB RAM, 2x SATA RAID1
The warning seems to come in average 3-4 times a minute:
2011-12-03 23:07:31 CET::@:[13728]: WARNING: pgstat wait timeout
2011-12-03 23:07:37 CET::@:[13728]: WARNING: pgstat wait timeout
2011-12-03 23:07:47 CET::@:[13556]: WARNING: pgstat wait timeout
2011-12-03 23:07:52 CET::@:[13729]: WARNING: pgstat wait timeout
Some non-default postgresql.conf settings:
shared_buffers = 6GB
effective_cache_size = 12GB
work_mem = 16MB
synchronous_commit = off
checkpoint_segments = 16
checkpoint_completion_target = 0.9
autovacuum_max_workers = 6
Is this a bug, something wrong with my setup, or simply harmless noise
(although annoying in that case)?
Regards,
-- a.