Re: Triggers or code?

From: André Fernandes <andre(dot)de(dot)camargo(dot)fernandes(at)hotmail(dot)com>
To: <dm(dot)aeqa(at)gmail(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Triggers or code?
Date: 2010-08-23 19:13:51
Message-ID: COL112-W18CB91E00A2DE2450FC0458A820@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


Trigger is the way to go.

André.

Date: Mon, 23 Aug 2010 11:42:21 -0700
Subject: [PERFORM] Triggers or code?
From: dm(dot)aeqa(at)gmail(dot)com
To: pgsql-performance(at)postgresql(dot)org

Hello There,

I have a table x and a history table x_hist, whats the best way to update the history table.

should i need to use triggers or embed a code in my script to update the history table?

what is the performance impact of a trigger versus embedding the code in the script?

thanks for your time.

- Deepak

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message David Kerr 2010-08-23 22:15:56 PARSE WAITING
Previous Message DM 2010-08-23 18:42:21 Triggers or code?