On Wednesday 26 November 2003 16:38, Roger Ging wrote: > I just installed v7.4 and restored a database from v7.3.4. [snip]
Hmm - you seem to be getting different row estimates in the plan. Can you re-analyse both versions and post EXPLAIN ANALYSE rather than just EXPLAIN? > -> Seq Scan on program p (cost=0.00..15192.35 > rows=4335 width=20) > > planner results on 7.3.4: > > -> Index Scan using idx_program_mri_id_no_program on program > p (cost=0.00..3209.16 rows=870 width=20) -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster