Pallav Kalva <pkalva(at)deg(dot)cc> writes:
>> alter table common.string drop constraint pk_string_stringid;
>> explain analyze ... same query ...
> 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
pgsql-performance by date
|Next:||From: PFC||Date: 2005-01-28 17:14:14|
|Subject: Re: Bitmap indexes |
|Previous:||From: Pallav Kalva||Date: 2005-01-28 16:58:17|
|Subject: Re: Poor Performance on Postgres 8.0|