From: Merlin Moncure <mmoncure@gmail.com>
To: Bruno Wolff III <bruno@wolff.to>
To: Dan Harris <fbsd@drivefaster.net>
To: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: Help optimizing a slow index scan
Date: Fri, 17 Mar 2006 13:07:34 -0500
Message-ID: <b42b73150603171007h4de1a9f2g8523bda08f392258@mail.gmail.com> (raw)
In-Reply-To: <20060317173827.GB15967@wolff.to>
References: <4419DB50.10404@drivefaster.net>
<4419DC1C.9070806@drivefaster.net>
<684362e10603161915x431c6b08t@mail.gmail.com>
<441AD702.9020508@drivefaster.net>
<20060317173827.GB15967@wolff.to>
On 3/17/06, Bruno Wolff III <bruno@wolff.to> wrote:
> Have you looked at using the Earth Distance contrib module? If a spherical
> model of the earth is suitable for your application, then it may work for you
> and might be easier than trying to create Gist indexes yourself.
earth distance = great stuff. If the maximum error is known then you
can just pad the distance and filter the result on the client if exact
precision is needed.
Merlin
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: mmoncure@gmail.com, bruno@wolff.to, fbsd@drivefaster.net
Subject: Re: Help optimizing a slow index scan
In-Reply-To: <b42b73150603171007h4de1a9f2g8523bda08f392258@mail.gmail.com>
References: <4419DB50.10404@drivefaster.net> <4419DC1C.9070806@drivefaster.net> <684362e10603161915x431c6b08t@mail.gmail.com> <441AD702.9020508@drivefaster.net> <20060317173827.GB15967@wolff.to> <b42b73150603171007h4de1a9f2g8523bda08f392258@mail.gmail.com>
* 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