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
