Re: After insert trigger question

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: mmiranda(at)americatel(dot)com(dot)sv
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: After insert trigger question
Date: 2005-04-27 17:09:45
Message-ID: 20050427170945.GA62136@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Apr 27, 2005 at 10:38:48AM -0600, mmiranda(at)americatel(dot)com(dot)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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Typing80wpm 2005-04-27 17:12:34 Thanks for Rekall link!
Previous Message Enrico Weigelt 2005-04-27 17:07:43 Re: OpenRPT