Re: Triggers or code?

Поиск
Список
Период
Сортировка
От Bob Lunney
Тема Re: Triggers or code?
Дата
Msg-id 9650.2310.qm@web39702.mail.mud.yahoo.com
обсуждение исходный текст
Ответ на Triggers or code?  (DM <dm.aeqa@gmail.com>)
Список pgsql-performance
Дерево обсуждения
That depends on your application's requirements.  If a transaction on table X fails, do you still want the history (noting the failure)?  If so, go with embedding the code in your script.  If you only want history for successful transactions, a trigger will take care of that for you automatically.

Bob Lunney 

--- On Mon, 8/23/10, DM <dm.aeqa@gmail.com> wrote:

From: DM <dm.aeqa@gmail.com>
Subject: [PERFORM] Triggers or code?
To: pgsql-performance@postgresql.org
Date: Monday, August 23, 2010, 2:42 PM

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 по дате отправления:

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Are Indices automatically generated for primary keys?
Следующее
От: Bob Branch
Дата:
Сообщение: New servers, need suggestions for sensible tuning settings