Re: deferred foreign keys - Mailing list pgsql-performance

From Vivek Khera
Subject Re: deferred foreign keys
Date
Msg-id x7isjqcq3f.fsf@yertle.int.kciLink.com
Whole thread Raw
In response to deferred foreign keys  (Vivek Khera <khera@kcilink.com>)
Responses Re: deferred foreign keys  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-performance
>>>>> "CK" == Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:

>> One more question: does the FK checker know to skip checking a
>> constraint if the column in question did not change during an update?

CK> As of 7.4, yes the check is skipped.


Thanks.  Then it sorta makes it moot for me to try deferred checks,
since the Pimary and Foreign keys never change once set.  I wonder
what is making the transactions appear to run lockstep, then...


--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD  +1-301-869-4449 x806
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Use my (date) index, darn it!
Next
From: Christopher Browne
Date:
Subject: Re: Use my (date) index, darn it!