Re: Trigger with WHEN clause (WIP)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Trigger with WHEN clause (WIP)
Дата
Msg-id 29377.1255618395@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Trigger with WHEN clause (WIP)  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: Trigger with WHEN clause (WIP)  (Dimitri Fontaine <dfontaine@hi-media.com>)
Список pgsql-hackers
Pavel Stehule <pavel.stehule@gmail.com> writes:
> 2009/10/15 Tom Lane <tgl@sss.pgh.pa.us>:
>> This seems to me to be a lot of code to accomplish nothing useful.

> I disagree. When I analysed speed of some operations, I found some
> unwanted trigger calls should to slow down applications. I am for any
> method, that could to decrease trigger calls.

That argument is based on a completely evidence-free assumption, namely
that this patch would make your case faster.  Executing the WHEN tests
is hardly going to be zero cost.  It's not too hard to postulate cases
where implementing a filter this way would be *slower* than doing it
inside the trigger.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [PATCH] Largeobject access controls
Следующее
От: Tom Lane
Дата:
Сообщение: Re: EXPLAIN BUFFERS