Opened 9 years ago

Last modified 9 years ago

#3479 closed defect

ST_ClusterKMeans hangs — at Initial Version

Reported by: robe Owned by: pramsey
Priority: blocker Milestone: PostGIS 2.3.0
Component: postgis Version: master
Keywords: Cc:

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.

Change History (0)

Note: See TracTickets for help on using tickets.