Excerpts from Steve Crawford's message of mar dic 27 22:51:06 -0300 2011: > I have a system (9.0.4 on Ubuntu Server 10.04 LTS x86_64) that is > currently in test/dev mode. I'm currently seeing the following messages > occurring every few seconds: > > ... > Dec 27 17:43:22 foo postgres[23693]: [6-1] : WARNING: pgstat wait timeout > Dec 27 17:43:27 foo postgres[27324]: [71400-1] : WARNING: pgstat wait > timeout > Dec 27 17:43:33 foo postgres[23695]: [6-1] : WARNING: pgstat wait timeout > Dec 27 17:43:54 foo postgres[27324]: [71401-1] : WARNING: pgstat wait > timeout
Hm, so can you strace the stats collector to see what it's doing? Maybe grab a backtrace with GDB from it before anything else. My guess is 27324 is the autovac launcher and the others are autovac workers just as they die. -- Álvaro Herrera <alvhe...@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
