[postgis-tickets] [SCM] PostGIS branch master updated. 3.2.0-688-gd45a98203

[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  d45a98203641e8f066929dd2126176f9bd19ca6b (commit)
      from  b0741830443c896ebbf15b51486a2b23787b7485 (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 d45a98203641e8f066929dd2126176f9bd19ca6b
Author: Sandro Santilli <strk at kbt.io>
Date:   Thu Mar 31 13:17:47 2022 +0200

    Add indices on edge_data.abs_next_{left,right}_edge
    
    This speeds up foreign key constraints checking upon
    removal or editing of edges.
    
    See https://trac.osgeo.org/postgis/ticket/2083#comment:20
    
    Closes #2083 again

diff --git a/NEWS b/NEWS
index 29571a06e..bf49a58cb 100644
--- a/NEWS
+++ b/NEWS
@@ -7,8 +7,8 @@ PostGIS 3.3.0dev
  * Enhancements *
   - #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)
+  - #2083, Speed up ST_RemEdge topology functions adding index on
+    relation(element_id) and edge_data(abs_next*) (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 14d2b69e8..afc637a5d 100644
--- a/topology/sql/manage/CreateTopology.sql.in
+++ b/topology/sql/manage/CreateTopology.sql.in
@@ -175,6 +175,11 @@ BEGIN
         NEW.left_face, NEW.right_face, NEW.geom
       );
 
+      ------- Add support indices supporting edge linking foreign keys
+      ------- See https://trac.osgeo.org/postgis/ticket/2083#comment:20
+      CREATE INDEX ON %1$I.edge_data(abs_next_left_edge);
+      CREATE INDEX ON %1$I.edge_data(abs_next_right_edge);
+
       --------------} END OF edge CREATION
 
       --------------{ layer sequence

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

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


hooks/post-receive
-- 
PostGIS