Re: foreign keys and RI triggers

Stephan Szabo <sszabo@megazone.bigpanda.com> writes:
> On Thu, 26 May 2005, Tom Lane wrote:
>> The thoughts I've had about special-casing RI events to save memory
>> have to do with the idea of lossy storage.

> One problem with that is that it works for the constraint check but not
> for referential actions,

True.  But even fixing it only for constraint checks would be a win.

Sooner or later, we will have to implement spill-to-disk for the trigger
event queue anyway ...
        regards, tom lane