[postgis-tickets] [SCM] PostGIS branch master updated. 3.2.0-686-ge4495fb79

[git at osgeo.org]

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  e4495fb792fe31a87a84e92297d276baf254007a (commit)
      from  854103fa2e087b53485c8cf403a1fcb952146be2 (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 e4495fb792fe31a87a84e92297d276baf254007a
Author: Sandro Santilli <strk at kbt.io>
Date:   Wed Mar 30 20:49:43 2022 +0200

    Add index on node(containing_face)
    
    Closes #2861

diff --git a/NEWS b/NEWS
index cdbfff631..29571a06e 100644
--- a/NEWS
+++ b/NEWS
@@ -5,8 +5,10 @@ PostGIS 3.3.0dev
   - Drop support for PostgreSQL 9.6 and 10 (Regina Obe)
 
  * Enhancements *
-  - #2083, Add index on topology.relation(element_id) and use it from
-    RemEdge functions (Sandro Santilli)
+  - #2861, Add index on topology.node(containing_face) speeding up
+    splitting and merging of faces (Sandro Santilli)
+  - #2083, Add index on topology.relation(element_id) speeding up
+    removal of edges and nodes (Sandro Santilli)
   - #5118, Allow dropping topologies with missing topogeometry sequences
     (Sandro Santilli)
   - #5111, faster topology face MBR computation (Sandro Santilli)
diff --git a/topology/sql/manage/CreateTopology.sql.in b/topology/sql/manage/CreateTopology.sql.in
index 75cd3b956..14d2b69e8 100644
--- a/topology/sql/manage/CreateTopology.sql.in
+++ b/topology/sql/manage/CreateTopology.sql.in
@@ -87,6 +87,12 @@ BEGIN
       COMMENT ON TABLE %1$I.node IS
       'Contains node topology primitives';
 
+      ------- Add index on containing_face, to speed up
+      ------- topology editing (adding/removing faces)
+      ------- See http://trac.osgeo.org/postgis/ticket/2861
+      CREATE INDEX node_containing_face_idx
+        ON %1$I.node (containing_face);
+
       --------------} END OF node CREATION
 
       --------------{ edge CREATION

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

Summary of changes:
 NEWS                                      | 6 ++++--
 topology/sql/manage/CreateTopology.sql.in | 6 ++++++
 2 files changed, 10 insertions(+), 2 deletions(-)


hooks/post-receive
-- 
PostGIS