Update in trigger

Поиск
Список
Период
Сортировка
От Iklódi Lajos
Тема Update in trigger
Дата
Msg-id 3CAA7942.592D079B@mithrandir.hu
обсуждение исходный текст
Ответы Re: Update in trigger  (Jan Wieck <janwieck@yahoo.com>)
Список pgsql-sql
Hi,
I have a problem with trigger in 7.1.3.
I have a table with after insert trigger, which is making updates in
another table.
I recognized that the more records I have in first table the slower is
my insert.
If my trigger is doing something else, for example inserts in another
table, it becomes * 20 times * quicker, and the speed of my insert
doesn't depend on tablesize.
Don't I have to make updates in trigger?

Thanks in advance for any help.
Lajos




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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Upgrading PostgreSQL to 7.1.3
Следующее
От: "cristi69"
Дата:
Сообщение: Date