Opened 11 months ago
Closed 11 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;
Note:
See TracTickets
for help on using tickets.
Turns out this was a phantom generated by the PARANOIA setting making building collections very very Slow.