| 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: | Whole Thread | Raw Message | 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 |