[PERFORM] after upgrade 8.4->9.3 query is slow not using index scan

set postgresql / modify query / create some indexes / whatever, to get the same query running time in postgresql 9.3 as I had in 8.4 2. how is it possible for analyze to get same costs when the query running time is almost 100x higher. Thank You for any ideas on this. -- Matúš Svrček svr...@plainte

Re: [PERFORM] after upgrade 8.4->9.3 query is slow not using index scan

, which was generated by pg_upgrade script, which should have ran VACUUM on the database, the script name is analyze_new_cluster.sh. Maybe after re-running vacuum analyze the statistics somehow changed? Case closed, thank You. -- Matúš Svrček PlainText s.r.o. [www.plaintext.sk] svr...@plaintext.sk