Re: pre-commit triggers

Поиск
Список
Период
Сортировка
От Noah Misch
Тема Re: pre-commit triggers
Дата
Msg-id 20131119054529.GA952344@tornado.leadboat.com
обсуждение исходный текст
Ответ на pre-commit triggers  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: pre-commit triggers  (Andrew Dunstan <andrew@dunslane.net>)
Re: pre-commit triggers  (Robert Haas <robertmhaas@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Kohei KaiGai
Дата:
Сообщение: Re: shared memory message queues
Следующее
От: KONDO Mitsumasa
Дата:
Сообщение: Re: Improvement of pg_stat_statement usage about buffer hit ratio