Re: [pgsql-advocacy] 8.2 -> 8.3 performance numbers - Mailing list pgsql-performance

From Simon Riggs
Subject Re: [pgsql-advocacy] 8.2 -> 8.3 performance numbers
Date
Msg-id 1185372549.4146.33.camel@ebony.site
Whole thread Raw
In response to Re: [pgsql-advocacy] 8.2 -> 8.3 performance numbers  (Mario Weilguni <mweilguni@sime.com>)
List pgsql-performance
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


pgsql-performance by date:

Previous
From: Ansgar -59cobalt- Wiechers
Date:
Subject: Re: index over timestamp not being used
Next
From: "Merlin Moncure"
Date:
Subject: Re: [pgsql-advocacy] 8.2 -> 8.3 performance numbers