Re: Help optimizing a slow index scan - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: Help optimizing a slow index scan
Date
Msg-id b42b73150603171007h4de1a9f2g8523bda08f392258@mail.gmail.com
Whole thread Raw
In response to Re: Help optimizing a slow index scan  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: 11
Date:
Subject: Re: Background writer configuration
Next
From: Evgeny Gridasov
Date:
Subject: Re: Background writer configuration