Franck Routier <franck(dot)routier(at)axege(dot)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