Re: postgres/postgis indexes

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Antonio Muñoz <amrrfr(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: postgres/postgis indexes
Date: 2009-07-13 15:20:19
Message-ID: 1247498419.11347.1103.camel@ebony.2ndQuadrant
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2009-07-13 15:48:41 Re: Postgres 8.4 literal escaping
Previous Message Alan Millington 2009-07-13 15:10:30 Re: Problem with Check Constraint in pg_restore