Re: [PERFORM] Any ideas how can I speed up this query?

[林士博]

1 GB of ram is quite small.
I think it is worth to try creating an index on a combination of
columns(lat, lng).
So that Bitmap Heap Scan would be omitted.