Re: Use of Indexes - Mailing list pgsql-general

From Tom Lane
Subject Re: Use of Indexes
Date
Msg-id 26637.1118602021@sss.pgh.pa.us
Whole thread Raw
In response to Use of Indexes  ("Darrell A. Sullivan, II" <darrell@flores-associates.com>)
List pgsql-general
"Darrell A. Sullivan, II" <darrell@flores-associates.com> writes:
> I was wondering if someone could answer a question about how PostgreSQL uses
> indexes when performing queries. Particularly, I need to know if the query
> optimizer will use more than index for a query or if it only uses one.

Versions through 8.0 can only use one index per query (per table).  8.1
will be smarter though.

            regards, tom lane

pgsql-general by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: Case sensitivity
Next
From: Tom Lane
Date:
Subject: Re: Trying to get posgreSQL-8.0.3 up on Tiger 10.4.1