Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I assume we still need a queue for deferred triggers, right?
There's still a queue. But it saves fewer events for shorter intervals
than it used to. Example: in the present code, if you have *any*
deferred triggers (for INSERT, UPDATE, or DELETE) on a rel then queue
entries are made for *all* triggerable events (INSERT, UPDATE, or
DELETE) on that rel. In the proposed patch, if you have only an AFTER
INSERT trigger then no queue entries are made for UPDATE or DELETE
events, etc. This has a direct bearing on the number of queue entries
made in RI scenarios, since the RI triggers are for subsets of events.
regards, tom lane