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(at)matrix(dot)gatewaynet(dot)com
mantzios(at)softlab(dot)ece(dot)ntua(dot)gr