Re: Autovacuum daemon terminated by signal 11 - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Autovacuum daemon terminated by signal 11
Date
Msg-id 20090120121839.GA3940@alvh.no-ip.org
Whole thread Raw
In response to Re: Autovacuum daemon terminated by signal 11  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:

> Anyway, it happens consistently on my HP box.  I find that your proposed
> patch fixes it, but makes the "normal" path crash :-( --- the loop in
> do_autovacuum has to be executed in AutovacMemCxt, because it creates an
> Oid List that gets passed to vacuum() and had better not be in a
> transaction-lifetime context.  The attached modified patch works for me.

Committed this patch to both 8.1 and 8.2.  Thanks.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Get object creation sql script in psql client
Next
From: Alvaro Herrera
Date:
Subject: Re: conexiones ssl