Opened 6 months ago

Closed 6 months ago

#5657 closed defect (fixed)

ST_GeneratePoints performance regression

Reported by: pramsey Owned by: pramsey
Priority: high Milestone: PostGIS 3.5.0
Component: postgis Version: master
Keywords: Cc:

Description

By my testing, ST_GeneratePoints seems to have gotten about 20% slower in 3.5 versus 3.4. There was some churn in the code to fix a failure, but things that were meant to make it faster seem to have done the opposite.

WITH circle AS (
        SELECT 'POLYGON((1 0, 0 1, 15 16, 16 15, 1 0))'::geometry AS geom
),
pts AS (
        SELECT (ST_Dump(ST_GeneratePoints(geom, 50000))).geom AS geom
        FROM circle
)
SELECT 'generate_points_1', count(pts.geom)
FROM circle, pts;

Change History (1)

comment:1 by pramsey, 6 months ago

Resolution: fixed
Status: newclosed

Turns out this was a phantom generated by the PARANOIA setting making building collections very very Slow.

Note: See TracTickets for help on using tickets.