Re: Help optimizing a slow index scan

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