nearest neighbor search from xyz coordinates

Поиск
Список
Период
Сортировка
От Andreas Jochem
Тема nearest neighbor search from xyz coordinates
Дата
Msg-id 49059CF8.5010403@gmx.de
обсуждение исходный текст
Ответы Re: nearest neighbor search from xyz coordinates  ("Serge Fonville" <serge.fonville@gmail.com>)
Re: nearest neighbor search from xyz coordinates  (Angel Alvarez <clist@uah.es>)
Re: nearest neighbor search from xyz coordinates  ("Merlin Moncure" <mmoncure@gmail.com>)
Список pgsql-general
Hello,

I have a table containing x y z coordinates. But I have no geometry column?
Is it possible to find the k nearest neighbors of any point. Is there
something like a kd-tree Index in postgres???

I know, if i had a geometry column I could make use of the distance
function to find the k nearest neighbors. But my table has millions of
records, thus it would take a very long time to use the distance
function for each point.

Thanks in advance.

Andi

В списке pgsql-general по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: psql screen size
Следующее
От: Abdul Rahman
Дата:
Сообщение: Replication with slony-I