Triggers or code?

From: DM <dm(dot)aeqa(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Triggers or code?
Date: 2010-08-23 18:42:21
Message-ID: AANLkTingyH4s9ZUa9in0rtFsCOGXhu+dc++kmYt5yNaa@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message André Fernandes 2010-08-23 19:13:51 Re: Triggers or code?
Previous Message Scott Marlowe 2010-08-23 16:20:34 Re: Inefficient query plan