Re: Deferred constraint and delete performance

Поиск
Список
Период
Сортировка
От Віталій Тимчишин
Тема Re: Deferred constraint and delete performance
Дата
Msg-id 331e40661002140145l610042d8pc27c61e6c23463df@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Deferred constraint and delete performance  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance


2010/2/10 Tom Lane <tgl@sss.pgh.pa.us>
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.

What about disc access? Won't "working" with one table, then another be faster than working with both at the same time?

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

Предыдущее
От: Pierre Frédéric Caillaud
Дата:
Сообщение: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk?
Следующее
От: Reydan Cankur
Дата:
Сообщение: PostgreSQL on SMP Architectures