[postgis-users] ST_DWithin Performance

[Mark Cave-Ayland]

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