Radial searches of cartesian points? - Mailing list pgsql-general

From thatsanicehatyouhave@mac.com
Subject Radial searches of cartesian points?
Date
Msg-id 1D83F645-D4AC-4C75-86F2-453A0FB8DB56@mac.com
Whole thread Raw
Responses Re: Radial searches of cartesian points?  (Merlin Moncure <mmoncure@gmail.com>)
List 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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: help... lost database after upgrade from 9.0 to 9.1
Next
From: Merlin Moncure
Date:
Subject: Re: Radial searches of cartesian points?