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
itin RAM, and with sufficiently huge deferred updates/inserts/deletes it's possible for the backend to run out of RAM
touse.
>
>> 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
hasto be kept somewhere.
Well when you put it like that, it's so obvious. :)