[postgis-devel] [PostGIS] #1351: ST_Buffer around A LINESTRING crashes the database
PostGIS
trac at osgeo.org
Wed Dec 7 04:50:59 PST 2011
#1351: ST_Buffer around A LINESTRING crashes the database
----------------------+-----------------------------------------------------
Reporter: royl | Owner: pramsey
Type: defect | Status: new
Priority: critical | Milestone: PostGIS 2.0.0
Component: postgis | Version: 1.5.X
Keywords: |
----------------------+-----------------------------------------------------
Comment(by strk):
Confirmed. The buffer computation uses a lot of memory which may result in
an OOM condition causing the crash.
As a workaround you may try to compute the buffer incrementally where each
step should reduce the number of segments opefully making it easier on
memory.
Something like:
{{{
select st_buffer(st_buffer(st_buffer(st_buffer(st_buffer(the_geom, 1), 2),
7), 10), 30) from bad_raw_trajectory;
}}}
In any case this is a GEOS issue.
--
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1351#comment:5>
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