[postgis-tickets] [PostGIS] #3479: ST_ClusterKMeans hangs with one row (was: ST_ClusterKMeans hangs)

[PostGIS]

#3479: ST_ClusterKMeans hangs with one row
----------------------+---------------------------
  Reporter:  robe     |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  blocker  |  Milestone:  PostGIS 2.3.0
 Component:  postgis  |    Version:  trunk
Resolution:           |   Keywords:
----------------------+---------------------------
Description changed by robe:

Old description:

> 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.

New description:

 My postgres server just hangs. Simpler

 {{{
 DROP TABLE IF EXISTS parcels;
 CREATE TABLE parcels AS
 SELECT 1 AS parcel_id,
     ST_MakeEnvelope(0,0,200,200) 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#comment:1>
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.