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 66AD43A5DA5 for ; Fri, 28 Jan 2005 17:02:44 +0000 (GMT) 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 70716-08 for ; Fri, 28 Jan 2005 17:02:34 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 3FFD73A5C0F for ; Fri, 28 Jan 2005 17:02:33 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j0SH2UCj008991; Fri, 28 Jan 2005 12:02:31 -0500 (EST) To: Pallav Kalva Cc: PERFORM Subject: Re: Poor Performance on Postgres 8.0 In-reply-to: <41FA6F29.9060009@deg.cc> References: <41FA5726.7040502@deg.cc> <2581.1106929396@sss.pgh.pa.us> <41FA6F29.9060009@deg.cc> Comments: In-reply-to Pallav Kalva message dated "Fri, 28 Jan 2005 11:58:17 -0500" Date: Fri, 28 Jan 2005 12:02:30 -0500 Message-ID: <8990.1106931750@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/584 X-Sequence-Number: 10274 Pallav Kalva writes: >> begin; >> alter table common.string drop constraint pk_string_stringid; >> explain analyze ... same query ... >> rollback; >> > what do u mean by rollback exactly ? i can drop the pk constraint > and run explain analyze and see how it behaves. The point of the rollback is that you don't really make the pk constraint go away. It is gone from the perspective of the EXPLAIN, but after you rollback it's back again. Easier than rebuilding it... regards, tom lane