X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B397252C7A for ; Tue, 3 May 2005 12:11:31 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 46804-10 for ; Tue, 3 May 2005 15:11:27 +0000 (GMT) Received: from mail.openskysoftware.com (ip67-153-26-131.z26-153-67.customer.algx.net [67.153.26.131]) by svr1.postgresql.org (Postfix) with ESMTP id 36D0C53DCA for ; Tue, 3 May 2005 12:11:24 -0300 (ADT) Received: from [192.168.10.8] (helo=openskysoftware.com) by mail.openskysoftware.com with esmtp (Exim 4.30) id 1DSz3T-0004Hz-Sy for pgsql-performance@postgresql.org; Tue, 03 May 2005 10:11:23 -0500 Received: from [192.168.1.101] (HELO testbench.openskysoftware.com) by openskysoftware.com (CommuniGate Pro SMTP 4.2.9) with ESMTP id 261636 for pgsql-performance@postgresql.org; Tue, 03 May 2005 10:11:23 -0500 Subject: Foreign key constraints compile faster in 7.4 From: Ashish Arte Reply-To: ashish@openskysoftware.com To: pgsql-perform In-Reply-To: References: Content-Type: text/plain Organization: Open Sky Software Inc. Message-Id: <1115133083.3961.5.camel@skyserver1.openskysoftware.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 (1.4.5-9) Date: Tue, 03 May 2005 10:11:23 -0500 Content-Transfer-Encoding: 7bit X-Scan-Signature: af18dd7a9fb5c3c4828d91f7181742be X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200505/13 X-Sequence-Number: 12177 Hello Everybody, We recently upgraded to Postgres 7.4 from 7.3.9 and noticed that the foreign key constraints compile noticeably faster. In 7.3 the constraints would typically take more than an hour to run on our production data. Now they take a minute or two. Can anybody explain such a major performance improvement ? Thanks -- Ashish Arte Open Sky Software