index on points - Mailing list pgsql-general

From Peter Keller
Subject index on points
Date
Msg-id 39E2D10A.337A514C@bvv.bayern.de
Whole thread Raw
Responses Re: index on points  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi all,
we are just programming a Geographical Information System for the hole
country of Bavaria.
Therefore we decided to use PostgreSQL as our DB. At this time we have
the problem to find points in a polygon. In postgres you have the
operator '@' to find points in a polygon. But if you have many points it
is realy to slow without indexing the points.
In the TODO list I saw it is planned to create an index on points and
other geometric types. Will it be implemented at any of the next
releases?
Has someone any idea to realize it now on another way?
Thanks for helping,
Peter
--
        Bezirksfinanzdirektion Muenchen
              Vermessungsabteilung
.........................................................
 Peter Keller        :  Tel: (+49) 089-2190-2594
 Vermessungsrat     :  Fax: (+49) 089-2190-2459
 Alexandrastr. 3    :  mailto:Peter.Keller@bvv.bayern.de
 80538 Muenchen        :  web: http://www.bayern.de/vermessung

pgsql-general by date:

Previous
From: tolik@aaanet.ru (Anatoly K. Lasareff)
Date:
Subject: Re: multi-national character sets?
Next
From: Peter Mount
Date:
Subject: Re: Re: JDBC Performance