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? ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
