Re: Postgres using up all my memory - Mailing list pgsql-general

From Eric Jain
Subject Re: Postgres using up all my memory
Date
Msg-id 420391FA.7040000@isb-sib.ch
Whole thread Raw
In response to Re: Postgres using up all my memory  (Bruno Wolff III <bruno@wolff.to>)
List 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!

pgsql-general by date:

Previous
From: George Essig
Date:
Subject: Re: Problem resolved (tsearch2 inhibiting migration)
Next
From: Bricklen Anderson
Date:
Subject: Re: Invalid headers and xlog flush failures