Re: [PERFORM] Poor Performance on Postgres 8.0

[Pallav Kalva]

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