On Sat, Feb 03, 2007 at 14:00:26 -0500,
Mark Stosberg <[EMAIL PROTECTED]> wrote:
>
> I'm using geo_distance() from contrib/earthdistance would like to find a
> way to spend up the geo distance calculation if possible. This is for a
> proximity search: "Show me adoptable pets within 250 miles of
Mark,
in astronomy we extensively use such kind of query, which we call
radial search or conesearch. There are several algorithms which perform
efficiently such query using spherical coordinates.
Specifically, we use our Q3C algorithm, see
http://www.sai.msu.su/~megera/wiki/SkyPixelization for
Hello,
I'm using geo_distance() from contrib/earthdistance would like to find a
way to spend up the geo distance calculation if possible. This is for a
proximity search: "Show me adoptable pets within 250 miles of this
zipcode".
I'm researched a number of approaches to this, but none seem as wor
Tom Lane wrote:
Since this is just a bog-standard Mini with 512M memory, it was pretty
thoroughly on its knees by this point :-(. I'm not sure how to find out
about allocated swap space in OS X, but my bet is that the above message
should be understood as "totally out of virtual memory".
just
