Tom Lane wrote:

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?


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






---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Reply via email to