From: Mark Stosberg <mark@summersault.com>
To: pgsql-performance@postgresql.org
Subject: what worked: performance improvements for geo-spatial searching on FreeBSD
Date: Mon, 07 Apr 2008 14:35:14 -0400
Message-ID: <ftdph3$nid$1@ger.gmane.org> (raw)
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-spatial calculations, also in available in contrib/
In our case, the slight loss of precision between the two methods didn't
matter.
The other things that made a noticeable performance improvement was
upgrading our servers from FreeBSD 4.x or 5.x (old, I know!) to FreeBSD
6.2 or later. We also upgrade these systems from PostgreSQL 8.1 to 8.2
at the same time. I assume the upgrade to 8.2 must be responsible at
least in part for the performance gains.
The result of these two rounds of updates is that our overall CPU
capacity in the cluster seems to be double or triple what it was before.
As the site grows we continue to be very happy with the performance,
features and stability of PostgreSQL.
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: <ftdph3$nid$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