From: Mark Stosberg <mark@summersault.com>
To: pgsql-performance@postgresql.org
Subject: Re: what worked: performance improvements for geo-spatial searching on FreeBSD
Date: Tue, 08 Apr 2008 09:45:07 -0400
Message-ID: <ftfst3$19r$1@ger.gmane.org> (raw)
In-Reply-To: <Pine.LNX.4.64.0804072246230.21547@sn.sai.msu.ru>
References: <ftdph3$nid$1@ger.gmane.org>
<Pine.LNX.4.64.0804072246230.21547@sn.sai.msu.ru>
Oleg Bartunov wrote:
> Mark,
>
> do you know about our sky segmentation code Q3C,
> see details http://www.sai.msu.su/~megera/wiki/SkyPixelization
> We use it for billions objects in database and quite happy.
Oleg,
Thanks for the response. That sounds interesting, but it's not clear to
me how I would put together a geo-spatial search calculating distances
around the curvature of the earth using this technique. Is there is a
SQL sample for this that you could point to?
Also, I didn't recognize the names of the techniques you were
benchmarking against "RADEC" and "Rtree", are either of these related to
the "earthdistance" or "cube()" based searches I would have used already?
Mark
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mark@summersault.com
Subject: Re: what worked: performance improvements for geo-spatial searching on FreeBSD
In-Reply-To: <ftfst3$19r$1@ger.gmane.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox