[postgis-tickets] [SCM] PostGIS branch master updated. 3.3.0rc2-566-gf2ef171d8

git at osgeo.org git at osgeo.org
Thu Jan 26 01:09:29 PST 2023


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  f2ef171d8cf5742a049ee882a81d3b43795b868f (commit)
      from  a27677b660239589bfa4e090e0f04fac1f235f38 (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 f2ef171d8cf5742a049ee882a81d3b43795b868f
Author: Sandro Santilli <strk at kbt.io>
Date:   Thu Jan 26 10:09:15 2023 +0100

    Add TopoGeometry performance test

diff --git a/topology/test/perf/TopoGeometry.sql b/topology/test/perf/TopoGeometry.sql
new file mode 100644
index 000000000..2e20b59ac
--- /dev/null
+++ b/topology/test/perf/TopoGeometry.sql
@@ -0,0 +1,19 @@
+BEGIN;
+
+SELECT topology.CreateTopology('topoperf_topogeometry');
+
+CREATE TABLE topoperf_topogeometry.layer(x int, y int);
+
+SELECT AddTopoGeometryColumn('topoperf_topogeometry','topoperf_topogeometry','layer','tg','POLYGON');
+
+\timing on
+INSERT INTO topoperf_topogeometry.layer(x, y, tg)
+  SELECT x, y,
+    toTopoGeom(
+      ST_Buffer(ST_MakePoint(x,y), 2),
+      'topoperf_topogeometry',
+      1
+    )
+  FROM
+    generate_series(-100, 100, 3) x,
+    generate_series(-100, 100, 3) y;

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

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


hooks/post-receive
-- 
PostGIS


More information about the postgis-tickets mailing list