From: | "Manos Tsagias" <tsagias(at)gmail(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #4004: out of memory |
Date: | 2008-03-01 18:22:41 |
Message-ID: | 27def3c70803011022s7d03b865k9fb9067c53e1c7aa@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Euler Taveira de Oliveira | 2008-03-01 19:50:46 | Re: ecpg produces code that won't compile |
Previous Message | Tom Lane | 2008-03-01 18:19:38 | Re: BUG #4004: out of memory |