Re: postgres/postgis indexes - Mailing list pgsql-general

From Simon Riggs
Subject Re: postgres/postgis indexes
Date
Msg-id 1247498419.11347.1103.camel@ebony.2ndQuadrant
Whole thread Raw
In response to postgres/postgis indexes  (Antonio Muñoz <amrrfr@gmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Tim Landscheidt
Date:
Subject: PostgreSQL 8.4 packages for Fedora 11?
Next
From: Alvaro Herrera
Date:
Subject: Re: Postgres 8.4 literal escaping