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?
> -> S
I just installed v7.4 and restored a database from v7.3.4. I have an
index based on a function that the planner is using on the old version,
but doing seq scans on left joins in the new version. I have run
analyze on the table post restore. the query returns in less than 1
second on version 7