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