Thread: Wrong index usage in 7.3.2
Hi, this is in continuation from the previous http://archives.postgresql.org/pgsql-performance/2003-05/msg00003.php thread. Summary: On a table i have this situation: on the queries i do, the best plan is used only if NO statistics are produced (via ANALYZE). Once i run [VACUUM] [FULL] ANALYZE; the correct index is used only in certain circumstances, and the planner fails to use it in the most common ones. Since Message http://archives.postgresql.org/pgsql-performance/2003-05/msg00003.php had no responces, i thought that the best way to solve the problem is to provide the pg_dump for anyone willing to examine the case. bzip2'ed it is about 355K. Thanx. -- ================================================================== Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel: +30-210-8981112 fax: +30-210-8981877 email: achill@matrix.gatewaynet.com mantzios@softlab.ece.ntua.gr