On Tue, 24 Aug 2004, PostgreSQL Bugs List wrote:
Quote:
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?
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
Re: [BUGS] BUG #1229: memory leak in backend with COPY and FOREIGN -
08-24-2004
, 12:27 PM
Linear Mode
