Re: Use of Indexes

"Darrell A. Sullivan, II"  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