Re: Postgresql 7.4.3/8.2.4 out of memory - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Postgresql 7.4.3/8.2.4 out of memory
Date
Msg-id 20070606085138.GB8997@svana.org
Whole thread Raw
In response to Postgresql 7.4.3/8.2.4 out of memory  (Christophe Combet PBIL/IBCP/CNRS <c.combet@ibcp.fr>)
List pgsql-general
On Wed, Jun 06, 2007 at 10:57:25AM +0200, Christophe Combet PBIL/IBCP/CNRS wrote:
> Dear all,
>
>
> With the below transaction we got an out of memory error.

<snip>

Here's your problem:

> AfterTriggerEvents: 3170885632 total in 397 blocks; 12200 free (384
> chunks); 3170873432 used

You've got some kind of deferred constraint/trigger and it's running
out of memory trying to remember what it has deferred. The two ways I
know to deal with this are:
1. Make the constraint immediate, somehow
2. Temporarily disable the constraint.

Maybe someone else has an idea?

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

pgsql-general by date:

Previous
From: Christophe Combet PBIL/IBCP/CNRS
Date:
Subject: Postgresql 7.4.3/8.2.4 out of memory
Next
From: Franz.Rasper@izb.de
Date:
Subject: Re: Corruption of files in PostgreSQL