[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