Re: After insert trigger question - Mailing list pgsql-general

From Michael Fuhr
Subject Re: After insert trigger question
Date
Msg-id 20050427170945.GA62136@winnie.fuhr.org
Whole thread Raw
In response to Re: After insert trigger question  (mmiranda@americatel.com.sv)
List 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 by date:

Previous
From: mmiranda@americatel.com.sv
Date:
Subject: Re: After insert trigger question
Next
From: "Mak, Jason"
Date:
Subject: populating a table via the COPY command using C code.