Radial searches of cartesian points?

Поиск
Список
Период
Сортировка
От thatsanicehatyouhave@mac.com
Тема Radial searches of cartesian points?
Дата
Msg-id 1D83F645-D4AC-4C75-86F2-453A0FB8DB56@mac.com
обсуждение исходный текст
Ответы Re: Radial searches of cartesian points?  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-general
Hi,

I have a data set of several hundred thousand points. Each point is saved as a three dimensional coordinate, i.e. (x,
y,z). What I'd like to do is given a point in that space, get a list of all of the points in the table within some
radius.

I'm familiar with the q3c package that does this for points that lie on a sphere, but is there something comparable for
radialsearches on 3D cartesian points? Speed is definitely an issue given the number of points I have. 

Thanks for any suggestions!

Cheers,
Demitri


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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: help... lost database after upgrade from 9.0 to 9.1
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: Radial searches of cartesian points?