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