[postgis-tickets] [PostGIS] #2354: ST_Union performance problem

[PostGIS]

#2354: ST_Union performance problem
-------------------------+--------------------------------------------------
 Reporter:  akrherz      |       Owner:  pramsey
     Type:  enhancement  |      Status:  new    
 Priority:  medium       |   Milestone:         
Component:  postgis      |     Version:  1.5.X  
 Keywords:               |  
-------------------------+--------------------------------------------------

Comment(by akrherz):

 so I had to cull some geometries to get under the 5 MB limit, with the
 culled geometries removed from the query I get:

     NOTICE:  TopologyException: found non-noded intersection between
 LINESTRING (-77.0096 35.0631, -77.0089 35.0628) and LINESTRING (-77.0089
 35.0628, -77.0089 35.0628) at -77.008930136999936 35.062848054000028

 Here's the larger file with the other 3 geometries included:

 http://mesonet.agron.iastate.edu/pickup/postgis/st_union_problem.dump

 I don't get the topologyexception when they are included, just very slow.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2354#comment:1>
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.