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