[postgis-devel] [PostGIS] #1798: Performance issue with ST_Intersects(geometry, geometry)

PostGIS trac at osgeo.org
Wed Jun 13 06:26:14 PDT 2012


#1798: Performance issue with ST_Intersects(geometry,geometry)
---------------------+------------------------------------------------------
 Reporter:  nicklas  |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.0.1
Component:  postgis  |     Version:  2.0.x        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by nicklas):

 That was interesting. I still have the issue with the trunk from
 yesterday.

 That could indicate that there is a difference in handling between
 POstgreSQL 8.4 and PostgreSQL 9.1.3 that I am running. I will install
 PostgreSQL 8.4 and test.

 Now I have used:
 "POSTGIS="2.1.0SVN r9904" GEOS="3.4.0dev-CAPI-1.8.0 r3673" PROJ="Rel.
 4.8.0, 20 February 2012" GDAL="GDAL 1.9.0, released 2011/12/29"
 LIBXML="2.8.0" LIBJSON="UNKNOWN" RASTER"
 on:
 "PostgreSQL 9.1.3 on x86_64-unknown-linux-gnu, compiled by gcc-4.4.real
 (Debian 4.4.5-8) 4.4.5, 64-bit"

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1798#comment:11>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-devel mailing list