Re: Autovacuum seems to block database: WARNING worker took too long to start - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: Autovacuum seems to block database: WARNING worker took too long to start
Date
Msg-id 1289918622-sup-8461@alvh.no-ip.org
Whole thread Raw
In response to Re: Autovacuum seems to block database: WARNING worker took too long to start  (Pablo Delgado Díaz-Pache <delgadop@gmail.com>)
Responses Re: Autovacuum seems to block database: WARNING worker took too long to start  (Pablo Delgado Díaz-Pache <delgadop@gmail.com>)
List pgsql-admin
Excerpts from Pablo Delgado Díaz-Pache's message of lun nov 15 04:52:53 -0300 2010:

> > But it strikes me that the code comment is wrong in one significant way:
> > if the postmaster were failing to heed SIGUSR1 at all, you could reach
> > the timeout here, because the fork-failed signal wouldn't get sent.

Hmm, yeah, I guess I wasn't considering the idea that postmaster was so
busy with something else that it wouldn't be able to respond to the
launcher's requests.  As you say, if it went away entirely, autovacuum
would also suicide.

> > Could you try strace'ing the postmaster process to see what it's doing
> > when this is happening?
>
> I definitely will.

Yes, please.

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-admin by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: Postgres error: could not open relation base/xxxxx/yyyyy
Next
From: Pablo Delgado Díaz-Pache
Date:
Subject: Re: Autovacuum seems to block database: WARNING worker took too long to start