On Sep 27, 2011, at 6:37 PM, Craig Ringer wrote: > On 09/27/2011 12:54 PM, Ben Chobot wrote: >> >> My memory is fuzzy but as I recall, a possible downside to using >> deferred constraints was increased memory usage > > That's right. PostgreSQL doesn't currently support spilling of pending constraint information to disk; it has to keep it in RAM, and with sufficiently huge deferred updates/inserts/deletes it's possible for the backend to run out of RAM to use. > >> though I cannot see how at the moment. > > A list of which triggers to run, and on which tuples, must be maintained until those triggers are fired. That list has to be kept somewhere. Well when you put it like that, it's so obvious. :) -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
