[postgis-tickets] [PostGIS] #3479: ST_ClusterKMeans hangs

PostGIS trac at osgeo.org
Sat Feb 27 08:06:49 PST 2016


#3479: ST_ClusterKMeans hangs
---------------------+---------------------------
 Reporter:  robe     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  blocker  |  Milestone:  PostGIS 2.3.0
Component:  postgis  |    Version:  trunk
 Keywords:           |
---------------------+---------------------------
 I think it's memory exhaustion.  My postgres server just hangs.

 {{{
 -- generate sample parcel test
 -- has 8 parcels, works fine
 CREATE TABLE parcels AS
 SELECT row_number() OVER() AS parcel_id,
     ST_Subdivide(ST_Buffer('LINESTRING(0 100, 100 200)'::geometry,50,
 'endcap=flat'),8) As geom;


 -- now try to do a ST_ClusterKMeans
 SELECT ST_ClusterKMeans(geom,3) over () AS cid, geom
 FROM parcels;


 }}}

 My server just hangs not sure what it's doing.  I had to kill all my
 postgres processes.

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3479>
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-tickets mailing list