Re: Deferred constraint and delete performance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Franck Routier <franck.routier@xxxxxxxxx> 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

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux