Re: Poor Performance on Postgres 8.0 - Mailing list pgsql-performance

From Tom Lane
Subject Re: Poor Performance on Postgres 8.0
Date
Msg-id 8990.1106931750@sss.pgh.pa.us
Whole thread Raw
In response to Re: Poor Performance on Postgres 8.0  (Pallav Kalva <pkalva@deg.cc>)
Responses Re: Poor Performance on Postgres 8.0  (Pallav Kalva <pkalva@deg.cc>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Pallav Kalva
Date:
Subject: Re: Poor Performance on Postgres 8.0
Next
From: PFC
Date:
Subject: Re: Bitmap indexes