Re: pre-commit triggers - Mailing list pgsql-hackers

From Noah Misch
Subject Re: pre-commit triggers
Date
Msg-id 20131119054529.GA952344@tornado.leadboat.com
Whole thread Raw
In response to pre-commit triggers  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: pre-commit triggers  (Andrew Dunstan <andrew@dunslane.net>)
Re: pre-commit triggers  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Fri, Nov 15, 2013 at 01:01:48PM -0500, Andrew Dunstan wrote:
> The triggers don't fire if there is no real XID, so only actual data  
> changes should cause the trigger to fire.

What's the advantage of this provision?  Without it, an individual trigger
could make the same check and drop out quickly.  A trigger not wanting it
can't so easily work around its presence, though.  Heretofore, skipping XID
assignment has been an implementation detail that improves performance without
otherwise calling user attention to itself.  This provision would make the
decision to acquire an XID (where optional) affect application behavior.

Thanks,
nm

-- 
Noah Misch
EnterpriseDB                                 http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Kohei KaiGai
Date:
Subject: Re: shared memory message queues
Next
From: KONDO Mitsumasa
Date:
Subject: Re: Improvement of pg_stat_statement usage about buffer hit ratio