WARNING: pgstat wait timeout
От | Anders Steinlein |
---|---|
Тема | WARNING: pgstat wait timeout |
Дата | |
Msg-id | 4EDAABA8.6020909@steinlein.no обсуждение исходный текст |
Список | pgsql-hackers |
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.
В списке pgsql-hackers по дате отправления: