index on points

Поиск
Список
Период
Сортировка
От Peter Keller
Тема index on points
Дата
Msg-id 39E2D10A.337A514C@bvv.bayern.de
обсуждение исходный текст
Ответы Re: index on points  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: tolik@aaanet.ru (Anatoly K. Lasareff)
Дата:
Сообщение: Re: multi-national character sets?
Следующее
От: Peter Mount
Дата:
Сообщение: Re: Re: JDBC Performance