Deferred constraints performance impact ?

From: "mark" <dvlhntr(at)gmail(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Deferred constraints performance impact ?
Date: 2012-07-20 02:27:38
Message-ID: 01a701cd661f$3cc05770$b6410650$@com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi all,

We have put some deferred constraints (some initially immediate, some
initially deferred) into our database for testing with our applications.

I haven't seen any noticeable loss in performance, but I am not sure I can
properly simulate our full production environment load levels in my tests.
I was wondering if I am turning on something that has known significant
negative impacts to performance, just from having them there.

I understand a lot more may have to be tracked through a transaction and
there could be some impact from that. Similar to an after update trigger? Or
are the two not comparable in terms of impact from what is tracked and then
checked.

Anyways, just looking for feedback if anyone has any.

-Mark

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Laszlo Nagy 2012-07-20 07:10:23 Re: queries are fast after dump->restore but slow again after some days dispite vacuum
Previous Message Tom Lane 2012-07-19 21:02:08 Re: [PERFORM] DELETE vs TRUNCATE explanation