Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 9FB389FBA96
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 25 Jul 2007 11:08:31 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 95423-03 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 25 Jul 2007 11:08:28 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from mail01.enterprisedb.com (mail01.enterprisedb.com
 [63.246.7.168])
	by postgresql.org (Postfix) with ESMTP id A46FB9FB955
	for <pgsql-performance@postgresql.org>;
	Wed, 25 Jul 2007 11:08:28 -0300 (ADT)
thread-index: AcfOxU3W1LQjxzucThOrluQ+MfHkaA==
Received: from [172.24.32.45] ([62.232.55.118]) by mail01.enterprisedb.com
	with Microsoft SMTPSVC(6.0.3790.3959);
	Wed, 25 Jul 2007 10:08:38 -0400
Content-Class: urn:content-classes:message
Importance: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.4073
Subject: Re: [pgsql-advocacy] 8.2 -> 8.3 performance numbers
From: "Simon Riggs" <simon@2ndquadrant.com>
To: "Mario Weilguni" <mweilguni@sime.com>
Cc: <pgsql-performance@postgresql.org>, "Josh Berkus" <josh@agliodbs.com>,
	"Jim Nasby" <decibel@decibel.org>
In-Reply-To: <200707251507.23951.mweilguni@sime.com>
References: <73185727-AD4A-4C97-B243-ADD2EE1875B5@decibel.org>
	<46A0EAE3.7030305@agliodbs.com>
	<1185367933.4146.13.camel@ebony.site>
	<200707251507.23951.mweilguni@sime.com>
Content-Type: text/plain;
	charset="iso-8859-1"
Date: Wed, 25 Jul 2007 15:09:09 +0100
Message-ID: <1185372549.4146.33.camel@ebony.site>
MIME-Version: 1.0
X-Mailer: Evolution 2.8.2 
Content-Transfer-Encoding: 7bit
X-OriginalArrivalTime: 25 Jul 2007 14:08:38.0718 (UTC)
	FILETIME=[4C4A85E0:01C7CEC5]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200707/341
X-Sequence-Number: 26025

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