[postgis-devel] [PostGIS] #182: query leads to memory exhaustion

[PostGIS]

#182: query leads to memory exhaustion
----------------------+-----------------------------------------------------
  Reporter:  akrherz  |       Owner:  pramsey
      Type:  defect   |      Status:  closed 
  Priority:  high     |   Milestone:         
 Component:  postgis  |     Version:         
Resolution:  wontfix  |    Keywords:         
----------------------+-----------------------------------------------------
Comment (by robe):

 Akrherz,

 It runs out of memory for me too in my GEOS 3.1.1 install, but works fine
 in my GEOS 3.2.0 SVN.  So I think this is another GEOS bug that can be
 resolved by upgrading to GEOS 3.2 trunk (not sure if the latest GEOS 3.1
 branch has the fix since I don't have that readily compiled).

 On a side note we don't have geomunion in PostGIS 1.4 or at least don't
 ahve it in my install, so I suspect unless you hacked your install, that
 geomunion function you have is from an older PostGIS install.  You should
 replace with st_union since its a much faster function and also your query
 will break should you ever get rid of your old lwgeom 1.3 so

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/182#comment:7>
PostGIS <http://trac.osgeo.org/postgis/>
PostGIS