index on points

From: Peter Keller <peter(dot)keller(at)bvv(dot)bayern(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: index on points
Date: 2000-10-10 08:19:22
Message-ID: 39E2D10A.337A514C@bvv.bayern.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)Keller(at)bvv(dot)bayern(dot)de
80538 Muenchen : web: http://www.bayern.de/vermessung

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Horst Herb 2000-10-10 08:31:29 Re: Question !
Previous Message Anatoly K. Lasareff 2000-10-10 08:12:05 Re: multi-national character sets?