Inefficiency in FK triggers

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Inefficiency in FK triggers
Дата
Msg-id 13053.1177360127@sss.pgh.pa.us
обсуждение исходный текст
Список pgsql-hackers
While poking at Michel Dorochevsky's issue, I noticed that if a DELETE
is done in a table that is referenced by many different foreign keys,
we repeat the ri_Check_Pk_Match test over again for each FK.  Seems like
it would be nice to avoid this duplicated work.  But right now I don't
see any easy way to refactor the RI triggers for it --- the triggers are
independent.  Something to think about in future, maybe.
        regards, tom lane


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

Предыдущее
От: August Zajonc
Дата:
Сообщение: Re: Wild idea: 9.0?
Следующее
От: Neil Conway
Дата:
Сообщение: Re: Improving deadlock error messages