Thread: postgres/postgis indexes

Hi all.

Can you tell me if Postgres/Postgis can use both spatial and alfanumeric indexes, at the same time, in the same query?

Thanks in advance.

On Mon, 2009-07-13 at 12:11 +0200, Antonio Muñoz wrote:

> Can you tell me if Postgres/Postgis can use both spatial and
> alfanumeric indexes, at the same time, in the same query?

Yes, it can. Postgres will use all and any indexes available to it. In
some cases, multiple indexes of different types on the same table will
be used in a single query.

--
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support