From: Tom Lane <tgl@sss.pgh.pa.us>
To: Pallav Kalva <pkalva@deg.cc>
Cc: PERFORM <pgsql-performance@postgresql.org>
Subject: Re: Poor Performance on Postgres 8.0
Date: Fri, 28 Jan 2005 12:02:30 -0500
Message-ID: <8990.1106931750@sss.pgh.pa.us> (raw)
In-Reply-To: <41FA6F29.9060009@deg.cc>
References: <41FA5726.7040502@deg.cc>
<2581.1106929396@sss.pgh.pa.us>
<41FA6F29.9060009@deg.cc>
Pallav Kalva <pkalva@deg.cc> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, pkalva@deg.cc
Subject: Re: Poor Performance on Postgres 8.0
In-Reply-To: <8990.1106931750@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox