[postgis-tickets] [SCM] PostGIS branch master updated. 3.3.0rc2-402-gf29fb6eff

[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  f29fb6eff3f37ee95cbab8317f929c9b313863b1 (commit)
       via  12467c5eddfbaefa771d332e2e071f5698d2520a (commit)
      from  dd7642ea28694ebc7eddf549ca9dcb856793f974 (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 f29fb6eff3f37ee95cbab8317f929c9b313863b1
Author: Sandro Santilli <strk at kbt.io>
Date:   Thu Dec 15 12:39:47 2022 +0100

    Speedup topology validity check for coincident nodes
    
    The time required to check for coincident nodes
    in a topology with ~9.5 million nodes on my system
    goes from ~2 minutes down to 8 seconds with this change.
    
    With this change the planner uses 2 sequence scans and an
    hash join rather than an index scan and nested loop.
    
    Tested on PostgreSQL 13.

diff --git a/NEWS b/NEWS
index 26bae5461..45262c09d 100644
--- a/NEWS
+++ b/NEWS
@@ -18,6 +18,7 @@ xxxx/xx/xx
   - #635, honour --bindir (and --prefix) configure switch for executables (Sandro Santilli)
   - Honour --mandir (and --prefix) configure switch for man pages install path (Sandro Santilli)
   - Speed up check of topology faces without edges (Sandro Santilli)
+  - Speed up coincident nodes check in topology validation  (Sandro Santilli)
 
 * Bug Fix *
 
diff --git a/topology/sql/manage/ValidateTopology.sql.in b/topology/sql/manage/ValidateTopology.sql.in
index c7d946119..e36e036ee 100644
--- a/topology/sql/manage/ValidateTopology.sql.in
+++ b/topology/sql/manage/ValidateTopology.sql.in
@@ -649,7 +649,7 @@ BEGIN
       node a,
       node b
     WHERE a.node_id < b.node_id
-    AND ST_DWithin(a.geom, b.geom, 0) -- NOTE: see #1625 and #1789
+    AND a.geom = b.geom
     AND (
       bbox IS NULL
       OR (

commit 12467c5eddfbaefa771d332e2e071f5698d2520a
Author: Sandro Santilli <strk at kbt.io>
Date:   Thu Dec 15 12:48:53 2022 +0100

    Add missing entry about face without edges query speed up

diff --git a/NEWS b/NEWS
index 87a36be18..26bae5461 100644
--- a/NEWS
+++ b/NEWS
@@ -17,6 +17,7 @@ xxxx/xx/xx
   - #5092, reduce number of upgrade paths installed on system (Sandro Santilli)
   - #635, honour --bindir (and --prefix) configure switch for executables (Sandro Santilli)
   - Honour --mandir (and --prefix) configure switch for man pages install path (Sandro Santilli)
+  - Speed up check of topology faces without edges (Sandro Santilli)
 
 * Bug Fix *
 

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

Summary of changes:
 NEWS                                        | 2 ++
 topology/sql/manage/ValidateTopology.sql.in | 2 +-
 2 files changed, 3 insertions(+), 1 deletion(-)


hooks/post-receive
-- 
PostGIS