Postgres Pro
Downloads
Home   >   mailing lists

Re: Tell postgres which index to use? - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Tell postgres which index to use?
Date
Msg-id 200502090941.01447.josh@agliodbs.com
Whole thread Raw
In response to Tell postgres which index to use?  (Silke Trissl <trissl@informatik.hu-berlin.de>)
Responses Re: Tell postgres which index to use?
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Silke Trissl
Date:
Subject: Tell postgres which index to use?
Next
From: Silke Trissl
Date:
Subject: Re: Tell postgres which index to use?