Skip site navigation (1) Skip section navigation (2)

Re: BUG #1229: memory leak in backend with COPY and FOREIGN KEY

From: "Andreas Heiduk" <Andreas(dot)Heiduk(at)web(dot)de>
To: "AndreasHeiduk" <Andreas(dot)Heiduk(at)web(dot)de>,"StephanSzabo" <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1229: memory leak in backend with COPY and FOREIGN KEY
Date: 2004-08-25 18:07:40
Message-ID: 264447583@web.de (view raw or flat)
Thread:
Lists: pgsql-bugs
Hello!

After splitting the the job into smaller pieces (e.g. 18x 1Mrow) the backend process now seems to release the memory after each subjob. Therefore the trigger queue seems to be a good candidate. Until now this queue was unknown to me. 

Perhaps a note in the docu of COPY FROM and in the section "13.4.2 Use COPY FROM" within "Performance Tips" would prevent other people like me doing such bad things.

Many thanks for the fast  help.

Andreas Heiduk


Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> schrieb am 24.08.04 19:25:56:
> 
> 
> On Tue, 24 Aug 2004, PostgreSQL Bugs List wrote:
> 
> > I'm trying to COPY ~18Mrows into a table which has a foreign key to another
> > table. Memory and swap are exhausted and finaly the postgres.log says:
> 
> This is very possibly the space taken up by the trigger queue (which
> cannot currently spill out to disk). If you load a smaller number of rows
> does the space go up and then down after the copy ends?


_______________________________________________________________
SMS schreiben mit WEB.DE FreeMail - einfach, schnell und
kostenguenstig. Jetzt gleich testen! http://f.web.de/?mc=021192


pgsql-bugs by date

Next:From: Tom LaneDate: 2004-08-25 18:15:59
Subject: Re: TOAST error in 7.4.2 on frequently truncated tables
Previous:From: Josh BerkusDate: 2004-08-25 17:50:26
Subject: Re: TOAST error in 7.4.2 on frequently truncated tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group