Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: PFCDate: 2005-01-28 17:14:14
Subject: Re: Bitmap indexes
Previous:From: Pallav KalvaDate: 2005-01-28 16:58:17
Subject: Re: Poor Performance on Postgres 8.0

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group