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: [6-1] : WARNING: pgstat wait timeout
> Dec 27 17:43:27 foo postgres: [71400-1] : WARNING: pgstat wait
> Dec 27 17:43:33 foo postgres: [6-1] : WARNING: pgstat wait timeout
> Dec 27 17:43:54 foo postgres: [71401-1] : WARNING: pgstat wait
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 <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
In response to
pgsql-hackers by date
|Next:||From: Andrew Dunstan||Date: 2011-12-28 13:38:54|
|Subject: Re: Review of VS 2010 support patches|
|Previous:||From: Tatsuo Ishii||Date: 2011-12-28 12:03:44|
|Subject: Re: spinlocks on HP-UX|