[postgis-users] GiST index on multiple columns?

Markus Schaber schabios at logi-track.com
Mon Jan 10 07:06:41 PST 2005

Hi, Robin,

On Sat, 8 Jan 2005 01:30:11 -0500
Robin Chauhan <robin.chauhan at gmail.com> wrote:

> Also, I want to improve the performance of a query which involves
> conditions on both 2 spatial columns (of type 'geometry') and 3
> non-spatial columns (of type integer and float).    Now GiST indexes
> appear to only allow geometric columns to be indexed.  So I am
> considering storing/coercing numeric types into geometries, just to
> allow them to be indexed along with the geometries, hopefully
> improving performance.  The integer types have a relatively small
> number of distinct values (like 20).

As far as I remember, there were GIST implementations for numeric types
and others in contrib and on the GIST project site, maybe you find some
helpful information there.


markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 zürich
phone +41-43-888 62 52 | fax +41-43-888 62 53
mailto:schabios at logi-track.com | www.logi-track.com

More information about the postgis-users mailing list