Re: Deferred constraint and delete performance - Mailing list pgsql-performance

From Tom Lane
Subject Re: Deferred constraint and delete performance
Date
Msg-id 16009.1265813800@sss.pgh.pa.us
Whole thread Raw
In response to Deferred constraint and delete performance  (Franck Routier <franck.routier@axege.com>)
Responses Re: Deferred constraint and delete performance  (Andres Freund <andres@anarazel.de>)
Re: Deferred constraint and delete performance  (Віталій Тимчишин <tivv00@gmail.com>)
List pgsql-performance
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.

            regards, tom lane

pgsql-performance by date:

Previous
From: Franck Routier
Date:
Subject: Deferred constraint and delete performance
Next
From: "Ing. Marcos L. Ortiz Valmaseda"
Date:
Subject: Re: [GENERAL] PostgreSQL - case studies