[postgis-tickets] [PostGIS] #2974: ST_ConvexHull is uninterruptible

[PostGIS]

#2974: ST_ConvexHull is uninterruptible
---------------------+------------------------------------------------------
 Reporter:  strk     |       Owner:  pramsey     
     Type:  defect   |      Status:  new         
 Priority:  medium   |   Milestone:  PostGIS GEOS
Component:  postgis  |     Version:  2.1.x       
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by strk):

 A memory-friendlier example (takes around 5.2GB of RAM max):
 {{{
 time psql -f - <<EOF
 set statement_timeout to 5000; -- 5 seconds
 select
 st_npoints(st_convexhull(st_collect(ST_Segmentize(ST_Rotate(ST_MakeLine(ST_MakePoint(0+x,
 0),ST_MakePoint(400+x,400)), radians(x%180)), 1)))) from
 generate_series(0,100000) x;
 EOF
 }}}

 The above runs in 52 seconds, while the timeout asked for a max of 5
 seconds (you may need to allow for a slightly longer run in order to enter
 the ST_ConvexHull part).

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