Home > mailing lists

Re: Triggers or code? - Mailing list pgsql-performance

From	André Fernandes
Subject	Re: Triggers or code?
Date	August 23, 2010 19:14:00
Msg-id	COL112-W18CB91E00A2DE2450FC0458A820@phx.gbl Whole thread Raw
In response to	Triggers or code? (DM <dm.aeqa@gmail.com>)
List	pgsql-performance

Tree view

Trigger is the way to go.

André.

Date: Mon, 23 Aug 2010 11:42:21 -0700
Subject: [PERFORM] Triggers or code?
From: dm.aeqa@gmail.com
To: pgsql-performance@postgresql.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

pgsql-performance by date:

From: DM
Date: 23 August 2010, 18:42:30
Subject: Triggers or code?

From: David Kerr
Date: 23 August 2010, 22:16:08
Subject: PARSE WAITING

Re: Triggers or code? - Mailing list pgsql-performance

Previous

Next