Franck Routier <[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance