Re: Postgres using up all my memory

From: Eric Jain <Eric(dot)Jain(at)isb-sib(dot)ch>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres using up all my memory
Date: 2005-02-04 15:17:14
Message-ID: 420391FA.7040000@isb-sib.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bruno Wolff III wrote:
> I think deferred triggers can also use a lot of memory.

I do indeed have several columns with REFERENCES x DEFERRABLE INITIALLY
DEFERRED...

Next time I run the procedure, I will try dropping the foreign key
constraints first.

Incidently, would be nice if Postgres had something like Oracle's
NOVALIDATE clause, as I can be certain that the foreign keys are valid!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2005-02-04 15:19:21 Re: REPLICATION Solution for WINDOWS OS
Previous Message Bricklen Anderson 2005-02-04 15:14:14 Re: Invalid headers and xlog flush failures