subject:"\[GENERAL\] postgres\/postgis indexes"

Re: [GENERAL] postgres/postgis indexes

2009-07-13 Thread Simon Riggs

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 type

[GENERAL] postgres/postgis indexes

2009-07-13 Thread Antonio Muñoz

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.