[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