Brent Verner <brent(at)rcfile(dot)org> writes:
> Yes, and I'm seeing no new problems (so far), but there is a problem
> in the current copy.c. Running the following on unmodified 7.2b5
> causes the backend to consume 17-18Mb of memory.
Probably that's just the space consumed for the pending-trigger events
created by the AFTER trigger that implements the foreign key check.
There should be a provision for shoving that list out to disk when
it gets too large ... but it ain't happening for 7.2.
regards, tom lane