Silke,
> is there a way to tell Postgres which index to use when a query is
> issued in 7.4.2?
PostgreSQL adjusts usage through global parameters, statistics, and periodic
ANALYZE. Please post an EXPLAIN ANALYZE (not just EXPLAIN) for your query
and people on this list can help you with your specific problem.
--
Josh Berkus
Aglio Database Solutions
San Francisco
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
