[postgis-tickets] [SCM] PostGIS branch master updated. 3.3.0rc2-420-g732064a15

git at osgeo.org git at osgeo.org
Wed Dec 21 09:38:48 PST 2022


This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "PostGIS".

The branch, master has been updated
       via  732064a157813018763ce97a1ad68409c420a1e7 (commit)
      from  b49e4d876e1061375c33ccdd4110114f13142d6c (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit 732064a157813018763ce97a1ad68409c420a1e7
Author: Sandro Santilli <strk at kbt.io>
Date:   Wed Dec 21 18:37:57 2022 +0100

    Make TopoGeo_addLinestring performance test more costly
    
    Use more edges for rings, have more nodes of degree 2.
    Raises topology build time from ~3 secs to ~30 secs on my system.

diff --git a/topology/test/perf/TopoGeo_addLinestring.sql b/topology/test/perf/TopoGeo_addLinestring.sql
index 59e706a8e..f6066a127 100644
--- a/topology/test/perf/TopoGeo_addLinestring.sql
+++ b/topology/test/perf/TopoGeo_addLinestring.sql
@@ -4,8 +4,9 @@ SELECT topology.CreateTopology('topoperf');
 
 \timing on
 
-CREATE TABLE topoperf.case_full_coverage_no_holes
-AS SELECT ST_Boundary(geom) g FROM ST_SquareGrid(4, ST_MakeEnvelope(0,0,120,120));
+CREATE TABLE topoperf.case_full_coverage_no_holes AS
+SELECT ST_Subdivide(ST_Segmentize(ST_Boundary(geom), 0.5), 5) g
+FROM ST_SquareGrid(4, ST_MakeEnvelope(0,0,120,120));
 
 SELECT count(*) FROM (
   SELECT topology.TopoGeo_addLinestring('topoperf', g)
@@ -13,3 +14,5 @@ SELECT count(*) FROM (
 ) foo;
 
 \timing off
+
+SELECT TopologySummary('topoperf');

-----------------------------------------------------------------------

Summary of changes:
 topology/test/perf/TopoGeo_addLinestring.sql | 7 +++++--
 1 file changed, 5 insertions(+), 2 deletions(-)


hooks/post-receive
-- 
PostGIS


More information about the postgis-tickets mailing list