Re: Deferred constraint and delete performance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Deferred constraint and delete performance
Дата
Msg-id 16009.1265813800@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Deferred constraint and delete performance  (Franck Routier <franck.routier@axege.com>)
Ответы Re: Deferred constraint and delete performance  (Andres Freund <andres@anarazel.de>)
Re: Deferred constraint and delete performance  (Віталій Тимчишин <tivv00@gmail.com>)
Список pgsql-performance
Franck Routier <franck.routier@axege.com> writes:
> I am wondering if deferring foreign key constraints (instead of
> disableing them) would increase performance, compared to non deferred
> constraints

No, it wouldn't make any noticeable difference AFAICS.  It would
postpone the work from end-of-statement to end-of-transaction,
but not make the work happen any more (or less) efficiently.

            regards, tom lane

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

Предыдущее
От: Franck Routier
Дата:
Сообщение: Deferred constraint and delete performance
Следующее
От: "Ing. Marcos L. Ortiz Valmaseda"
Дата:
Сообщение: Re: [GENERAL] PostgreSQL - case studies