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
is:

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

                        regards, tom lane

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

Reply via email to