Re: Use of Indexes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Darrell A(dot) Sullivan, II" <darrell(at)flores-associates(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Use of Indexes
Date: 2005-06-12 18:47:01
Message-ID: 26637.1118602021@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Darrell A. Sullivan, II" <darrell(at)flores-associates(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-06-12 18:48:06 Re: Trying to get posgreSQL-8.0.3 up on Tiger 10.4.1
Previous Message Magnus Hagander 2005-06-12 18:32:51 Re: Case sensitivity