[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