On Wed, 2007-07-25 at 15:07 +0200, Mario Weilguni wrote:
> Am Mittwoch 25 Juli 2007 schrieb Simon Riggs:
> > I have reasonable evidence that Referential Integrity is the major
> > performance bottleneck and would like some objective evidence that this
> > is the case.
>
> Just curious, will 8.3 still check FK constraints (and use locks) even if the
> referencing column value does not change?
That is optimised away in 8.0+
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com