[postgis-users] ST_DWithin Performance

[strk]

On Thu, Feb 10, 2011 at 03:37:34PM -0800, Carl S. Yestrau Jr. wrote:
> I have a geography(Point,4326) column with a gist index with ~700K
> records. A simple query using the ST_DWithin() is taking about 15
> secs. Any pointers from the resident experts?

show explain analyze <yourselect> output ?

--strk;

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html