Re: Help optimizing a slow index scan

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Bruno Wolff III" <bruno(at)wolff(dot)to>, "Dan Harris" <fbsd(at)drivefaster(dot)net>, "PostgreSQL Performance" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Help optimizing a slow index scan
Date: 2006-03-17 18:07:34
Message-ID: b42b73150603171007h4de1a9f2g8523bda08f392258@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 3/17/06, Bruno Wolff III <bruno(at)wolff(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Evgeny Gridasov 2006-03-17 18:36:06 Re: Background writer configuration
Previous Message 11 2006-03-17 17:56:32 Re: Background writer configuration