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?
2. Have you ANALYZEd both tables lately?
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;
regards, tom lane