Re: Help optimizing a slow index scan

[Dan Harris <fbsd@xxxxxxxxxxxxxxx>]

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