"Darrell A. Sullivan, II" <darrell@xxxxxxxxxxxxxxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
