[PostGIS] #5657: ST_GeneratePoints performance regression

PostGIS trac at osgeo.org
Wed Jan 17 13:11:56 PST 2024


#5657: ST_GeneratePoints performance regression
---------------------+---------------------------
 Reporter:  pramsey  |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  high     |  Milestone:  PostGIS 3.5.0
Component:  postgis  |    Version:  master
 Keywords:           |
---------------------+---------------------------
 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;
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5657>
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