From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Christophe Combet PBIL/IBCP/CNRS <c(dot)combet(at)ibcp(dot)fr> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Postgresql 7.4.3/8.2.4 out of memory |
Date: | 2007-06-06 08:51:38 |
Message-ID: | 20070606085138.GB8997@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
From | Date | Subject | |
---|---|---|---|
Next Message | Franz.Rasper | 2007-06-06 08:56:16 | Re: Corruption of files in PostgreSQL |
Previous Message | Paolo Bizzarri | 2007-06-06 08:18:14 | Re: Corruption of files in PostgreSQL |