Re: Poor Performance on Postgres 8.0

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Pallav Kalva <pkalva(at)deg(dot)cc>
Cc: PERFORM <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Poor Performance on Postgres 8.0
Date: 2005-01-28 17:02:30
Message-ID: 8990.1106931750@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Pallav Kalva <pkalva(at)deg(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message PFC 2005-01-28 17:14:14 Re: Bitmap indexes
Previous Message Pallav Kalva 2005-01-28 16:58:17 Re: Poor Performance on Postgres 8.0