[postgis-devel] [PostGIS] #182: query leads to memory exhaustion
PostGIS
trac at osgeo.org
Wed Sep 23 18:29:09 PDT 2009
#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
More information about the postgis-devel
mailing list