[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