On 10/02/11 23:37, 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?
Arch Linux x86
postgis-1.5.2-1
postgresql-9.0.2-2
In order to help, we'd need a lot more information than this - in
particular the schema of the tables (\d in psql output) and the EXPLAIN
ANALYZE of the slow query would be the bare minimum information you'd
need to provide.
ATB,
Mark.
--
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063
Sirius Labs: http://www.siriusit.co.uk/labs
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users