Re: Trigger functions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Trigger functions
Дата
Msg-id 1230.1049213374@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Trigger functions  (Marc Drouin <marc.drouin@fondex.ca>)
Список pgsql-general
Marc Drouin <marc.drouin@fondex.ca> writes:
> The function is triggered on insert and is supposed to fill a field in the
> table based on three other fields of the same table (ex: field D = Field A X
> Field B X Field C).  The addition of the trigger to teh table has slowed
> down the insert procedd considerably.  It takes approximatly two second for
> a simple insert.

That's pretty slow, all right, but if you're not going to show us the
details there's not much advice we can offer.

            regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: dropping a table with dependencies
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: Newsgroups/sites for SQL questions?