Re: Tell postgres which index to use?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Silke Trissl <trissl(at)informatik(dot)hu-berlin(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Tell postgres which index to use?
Date: 2005-02-09 17:41:01
Message-ID: 200502090941.01447.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Silke Trissl 2005-02-09 17:58:02 Re: Tell postgres which index to use?
Previous Message Silke Trissl 2005-02-09 15:58:01 Tell postgres which index to use?