Re: [PERFORM] what worked: performance improvements for geo-spatial searching on FreeBSD

2008-04-07 Thread Oleg Bartunov
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 On Mon, 7 Apr 2008, Mark Stosberg wrote: The http://www.1-800-save-a-pet.com site is hosted with FreeBSD and P

[PERFORM] what worked: performance improvements for geo-spatial searching on FreeBSD

2008-04-07 Thread Mark Stosberg
The http://www.1-800-save-a-pet.com site is hosted with FreeBSD and PostgreSQL and as a geo-spatial search as a central feature. One thing that made a substantial performance improvement was switching from the "geo_distance()" search in the earthdistance contrib, to use the "cube" based geo-spati