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
