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 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
