Pallav Kalva <[EMAIL PROTECTED]> 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

        alter table common.string drop constraint pk_string_stringid;
        explain analyze ... same query ...

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to