"wmiro@xxxxxxxxx" <wmiro@xxxxxxxxx> writes: > Why the plan is worst in postgres 8.1? (1) you have not actually shown us that the plan is worse. If you are complaining that the planner is wrong, EXPLAIN output (which contains only the planner's estimates) is useless for proving your point. Show EXPLAIN ANALYZE. (2) Have you ANALYZEd these tables recently in either database? The discrepancies in estimated rowcounts suggest that the two planners are working with different statistics. regards, tom lane
