Search Postgresql Archives

Re: Postgresql 7.4.3/8.2.4 out of memory

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment: signature.asc
Description: Digital signature


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux