Skip site navigation (1) Skip section navigation (2)

Re: Possible patch to remove "triggered data change" support

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>, pgsql-patches(at)postgresql(dot)org
Subject: Re: Possible patch to remove "triggered data change" support
Date: 2001-11-13 01:37:46
Message-ID: 29709.1005615466@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-patches
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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

In response to

pgsql-patches by date

Next:From: Tom LaneDate: 2001-11-13 01:51:16
Subject: Re: Patch to add Heimdal kerberos support
Previous:From: Tom LaneDate: 2001-11-13 01:32:51
Subject: Re: ALTER TABLE RENAME fix

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group