Philippe Lang wrote:
> Hi,
>
> For an unknown reason, I cannot post this message to the mailing-list!
>
> Here it is:
>
> http://www.attiksystem.ch/postgresql-general.txt
Please post query and table structure as well. And since you are using a
medium with no limitation on line lenght, unwrap the query plan.
EXPLAIN ANALYZE output would more useful. Indeed, PG 8 believes it has
found a "better" plan than 7.4, costing only ~1.1 million units
(although these are probably not directly comparable).
Memory settings might be relevant - you may be comparing a vanilla
installation of 8.1 with a "tuned" 7.4.
/Nis