Re: [postgis-users] ST_DWithin is not using SpatialIndex with Subquery

2012-09-11 Thread Thomas Klemmer
n...@postgis.refractions.net] *De la part de* Thomas > Klemmer > *Envoyé :* mardi 11 septembre 2012 11:09 > *À :* postgis-users@postgis.refractions.net > *Objet :* [postgis-users] ST_DWithin is not using SpatialIndex with > Subquery > > Hi folks > > first of here some

Re: [postgis-users] ST_DWithin is not using SpatialIndex with Subquery

2012-09-11 Thread Francois Hugues
. De : postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] De la part de Thomas Klemmer Envoyé : mardi 11 septembre 2012 11:09 À : postgis-users@postgis.refractions.net Objet : [postgis-users] ST_DWithin is not using SpatialIndex with

[postgis-users] ST_DWithin is not using SpatialIndex with Subquery

2012-09-11 Thread Thomas Klemmer
Hi folks first of here some system informations: Server: Ubuntu 12.04 LTS, 16GB RAM 1TB 4x SSD HW Raid "PostgreSQL 9.1.5 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit" "POSTGIS="2.0.0 r9605" GEOS="3.3.3-CAPI-1.7.4" PROJ="Rel. 4.7.1, 23 September 2009"