Rules for trigger execution

Поиск
Список
Период
Сортировка
От pginfo
Тема Rules for trigger execution
Дата
Msg-id 3E37B6F0.F9905BAD@t1.unisoftbg.com
обсуждение исходный текст
Ответы Re: Rules for trigger execution  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
Hi,

Is it possible in pg to define rules for trigger execution.

I have a table with namy fields and have defined trigger ( in PL/SQL) on
updating.

If I try to update one field from the table and it is not includet in
trigger calculation,
pg takes about 15 min for updating 700K records.

If I do not have trigger installed all is ok as performance.

My Question is how to define that I need trigger execution by changin
only some fields from table?

Will be trigger execution faster if I write it in C ?

regards,
ivan.


В списке pgsql-general по дате отправления:

Предыдущее
От: Philip Rhoades
Дата:
Сообщение: Digest not working?
Следующее
От: "William J. Stotts"
Дата:
Сообщение: unsubscribe