Albert Vernon Smith <contact1@xxxxxxxxxxxx> writes: > I just re-checked, and all the same index definitions are on both > tables. Well, that seems to imply that the 8.0 planner is missing the plan that 7.4 finds ... which is both hard to believe and impossible to investigate with this much info. Would it be possible to get a copy of the database? Or at least a schema dump? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)