[SCM] PostGIS branch master updated. 3.4.0rc1-994-g865bfe8c6

git at osgeo.org git at osgeo.org
Fri Mar 8 01:09:21 PST 2024


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  865bfe8c67f877bd2a442804ebb9fd10dc4ae4dd (commit)
      from  6f25787f3dbe14cd140da83c6d790a24c10fbd62 (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 865bfe8c67f877bd2a442804ebb9fd10dc4ae4dd
Author: Sandro Santilli <strk at kbt.io>
Date:   Fri Mar 8 10:08:23 2024 +0100

    Add a topology performance test based on concentric linear rings
    
    References #3587

diff --git a/topology/test/perf/TopoGeo_addLinestring_concentricCircles.sql b/topology/test/perf/TopoGeo_addLinestring_concentricCircles.sql
new file mode 100644
index 000000000..57c1df2b8
--- /dev/null
+++ b/topology/test/perf/TopoGeo_addLinestring_concentricCircles.sql
@@ -0,0 +1,24 @@
+BEGIN;
+
+SELECT topology.CreateTopology('topoperf');
+
+CREATE TABLE topoperf.case_concentric_circles AS
+
+SELECT radius, ST_ExteriorRing(
+  ST_Buffer('POINT(0 0)', radius, 128)
+) g
+FROM generate_series(10, 100) radius;
+
+\timing on
+
+SELECT count(*) FROM (
+  SELECT topology.TopoGeo_addLinestring('topoperf', g)
+  FROM (
+    SELECT g FROM topoperf.case_concentric_circles
+    ORDER BY radius
+  ) bar
+) foo;
+
+\timing off
+
+SELECT TopologySummary('topoperf');

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

Summary of changes:
 .../TopoGeo_addLinestring_concentricCircles.sql    | 24 ++++++++++++++++++++++
 1 file changed, 24 insertions(+)
 create mode 100644 topology/test/perf/TopoGeo_addLinestring_concentricCircles.sql


hooks/post-receive
-- 
PostGIS


More information about the postgis-tickets mailing list