Re: BUG #4004: out of memory

Thank you Tom for the reply.

There are no AFTER trigger events defined, but there is one FK. I'll drop
the FK as you suggested.

Thank you again for your help.
Manos._

On Sat, Mar 1, 2008 at 7:19 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> "Manos Tsagias" <tsagias(at)gmail(dot)com> writes:
> > I used COPY to import a 2GB CSV file into a table. After almost 2 hours
> I
> > got:
> > ERROR: out of memory
>
> Looks like you're running out of memory for pending AFTER trigger
> events. What triggers or foreign keys have you got on that table?
>
> The usual recommendation for bulk loading into a table with a foreign
> key is to drop the FK constraint, bulk load, re-create the FK
> constraint. This will be significantly faster than allowing the FK
> to be checked incrementally. Yeah, it'd be nice if that were
> automated for you ...
>
> regards, tom lane
>