Re: Help optimizing a slow index scan

From: Dan Harris <fbsd(at)drivefaster(dot)net>
To: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Help optimizing a slow index scan
Date: 2006-03-17 15:34:26
Message-ID: 441AD702.9020508@drivefaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Markus Bertheau wrote:
> Have you tried using a GIST index on lat & long? These things are
> meant for two-dimensional data, whereas btree doesn't handle
> two-dimensional data that well. How many rows satisfy either of the
> long / lat condition?
>
>
>>
According to the analyze, less than 500 rows matched. I'll look into
GIST indexes, thanks for the feedback.

-Dan

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dan Harris 2006-03-17 15:53:44 Re: Help optimizing a slow index scan
Previous Message Kevin Grittner 2006-03-17 15:08:23 Re: Background writer configuration