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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

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