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