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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
