Re: After insert trigger question

Поиск
Список
Период
Сортировка
От Michael Fuhr
Тема Re: After insert trigger question
Дата
Msg-id 20050427170945.GA62136@winnie.fuhr.org
обсуждение исходный текст
Ответ на Re: After insert trigger question  (mmiranda@americatel.com.sv)
Список pgsql-general
On Wed, Apr 27, 2005 at 10:38:48AM -0600, mmiranda@americatel.com.sv wrote:
>
> What about performance, if its a matter of choice between after or before
> insert, what perform better?

According to the "Triggers" chapter in the documentation, "If you have
no specific reason to make a trigger before or after, the before case
is more efficient, since the information about the operation doesn't
have to be saved until end of statement."

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

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

Предыдущее
От: mmiranda@americatel.com.sv
Дата:
Сообщение: Re: After insert trigger question
Следующее
От: "Mak, Jason"
Дата:
Сообщение: populating a table via the COPY command using C code.