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