Re: Poor Performance on Postgres 8.0

Tom Lane wrote:

>Pallav Kalva <pkalva@deg.cc> writes:
>
>
>>     I  am running this query on postgres 8 beta version and it is not
>>using the right index, where as if i run the same query on postgres 7.4
>>version it uses the right  index .
>>
>>
>
>1. Beta which, exactly?
>

Beta 4

>
>2. Have you ANALYZEd both tables lately?
>
Yes

>
>3. If so, try this to see what it thinks the cost of the reverse plan
>is:
>
>    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.

>
>            regards, tom lane
>
>
>