Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 94B429FB8DD for ; Wed, 25 Jul 2007 10:07:23 -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 82517-02 for ; Wed, 25 Jul 2007 10:07:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from relay.icomedias.com (relay.icomedias.com [62.99.232.66]) by postgresql.org (Postfix) with ESMTP id 4A32B9FB731 for ; Wed, 25 Jul 2007 10:07:20 -0300 (ADT) Received: from loki.local ([10.192.17.128]) by relay.icomedias.com (8.13.7/8.13.7) with ESMTP id l6PD73h5002247; Wed, 25 Jul 2007 15:07:04 +0200 From: Mario Weilguni To: pgsql-performance@postgresql.org Subject: Re: [pgsql-advocacy] 8.2 -> 8.3 performance numbers Date: Wed, 25 Jul 2007 15:07:23 +0200 User-Agent: KMail/1.9.7 Cc: "Simon Riggs" , "Josh Berkus" , "Jim Nasby" References: <73185727-AD4A-4C97-B243-ADD2EE1875B5@decibel.org> <46A0EAE3.7030305@agliodbs.com> <1185367933.4146.13.camel@ebony.site> In-Reply-To: <1185367933.4146.13.camel@ebony.site> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200707251507.23951.mweilguni@sime.com> X-Scanned-By: MIMEDefang 2.57 on 10.192.64.104 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/339 X-Sequence-Number: 26023 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?