Re: Trigger is not firing immediately

Поиск
Список
Период
Сортировка
От Chris
Тема Re: Trigger is not firing immediately
Дата
Msg-id 487AF7AE.6020606@gmail.com
обсуждение исходный текст
Ответ на Trigger is not firing immediately  ("Praveen" <praveen.k@renaissance-it.com>)
Список pgsql-performance
Praveen wrote:
>
> Hi All,
>     I am having a trigger in table, If I update the the table manually
> trigger is firing immediately(say 200ms per row), But if I update the
> table through procedure the trigger is taking time to fire(say 7 to 10
> seconds per row).
>
> Please tell me what kind of changes can I make so that  trigger  fire
> immediately while updating the table through procedure ?

Sending the same email over and over again isn't going to get you a
response any quicker.

If you send the details of the trigger and the tables/fields it affects
then you might get a more helpful response.

--
Postgresql & php tutorials
http://www.designmagick.com/

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

Предыдущее
От: "A. Kretschmer"
Дата:
Сообщение: Re: Trigger is not firing immediately
Следующее
От: "Praveen"
Дата:
Сообщение: Re: Trigger is not firing immediately