Markus Bertheau wrote:
According to the analyze, less than 500 rows matched. I'll look into GIST indexes, thanks for the feedback.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?
-Dan ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
