[postgis-tickets] [SCM] PostGIS branch master updated. 3.2.0-728-g038a8e4d6

[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  038a8e4d6a1dfb293c018409c29b871dc16791fd (commit)
       via  adb8c0ad6e23d23522181746ff6894862b8b893b (commit)
       via  e45a45dafd6379d1b8e6da4d5085db49226e917d (commit)
      from  b39f921427795b27dc121d0de29950b9fac75c97 (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 038a8e4d6a1dfb293c018409c29b871dc16791fd
Merge: b39f92142 adb8c0ad6
Author: Regina Obe <lr at pcorp.us>
Date:   Fri Apr 15 13:04:07 2022 -0400

    PG15 Fast GIST index build (Sergei Shoulbakov)
    Closes #5135
    Closes https://github.com/postgis/postgis/pull/684
    Merge remote-tracking branch 'konturio/enable-sorsupport-2d'

diff --cc NEWS
index 68a10949c,840cf1d31..ba531bd9a
--- a/NEWS
+++ b/NEWS
@@@ -24,6 -24,7 +24,7 @@@ PostGIS 3.3.0de
    - ST_ConcaveHull GEOS 3.11+ native implementation (Paul Ramsey, Martin Davis)
    - #4574, GH678, #5121 Enable Link-Time Optimizations using --enable-lto (Sergei Shoulbakov)
    - GH676, faster ST_Clip (Aliaksandr Kalenik)
 -  - Fast GiST index build is enabled by default for PostgreSQL 15+ (Sergei Shoulbakov)
++  - #5135, Fast GiST index build is enabled by default for PostgreSQL 15+ (Sergei Shoulbakov)
  
   * New features *
    - #5116, Topology export/import scripts (Sandro Santilli)

commit adb8c0ad6e23d23522181746ff6894862b8b893b
Author: sergei sh <sshoulbakov at kontur.io>
Date:   Fri Apr 15 13:25:15 2022 +0300

    News: 2d sortsupport enabled for postgres 15+

diff --git a/NEWS b/NEWS
index e043379ff..840cf1d31 100644
--- a/NEWS
+++ b/NEWS
@@ -24,6 +24,7 @@ PostGIS 3.3.0dev
   - ST_ConcaveHull GEOS 3.11+ native implementation (Paul Ramsey, Martin Davis)
   - #4574, GH678, #5121 Enable Link-Time Optimizations using --enable-lto (Sergei Shoulbakov)
   - GH676, faster ST_Clip (Aliaksandr Kalenik)
+  - Fast GiST index build is enabled by default for PostgreSQL 15+ (Sergei Shoulbakov)
 
  * New features *
   - #5116, Topology export/import scripts (Sandro Santilli)

commit e45a45dafd6379d1b8e6da4d5085db49226e917d
Author: sergei sh <sshoulbakov at kontur.io>
Date:   Wed Apr 13 16:11:03 2022 +0300

    enable 2d sortsupport function for postgres >= 15

diff --git a/postgis/postgis.sql.in b/postgis/postgis.sql.in
index 115155764..05fb550b3 100644
--- a/postgis/postgis.sql.in
+++ b/postgis/postgis.sql.in
@@ -823,9 +823,13 @@ CREATE OPERATOR CLASS gist_geometry_ops_2d
 	OPERATOR        13       <-> FOR ORDER BY pg_catalog.float_ops,
 	OPERATOR        14       <#> FOR ORDER BY pg_catalog.float_ops,
 --
--- Note at 3.2: Sort support in bulk indexing not included in the
--- default opclass due to performance degredation in query
--- may be enabled in future versions.
+-- Sort support in bulk indexing not included in the default
+-- opclass for PostgreSQL versions <15 due to query performance
+-- degradation caused by GiST index page overlap.
+-- Since PostgreSQL 15 sorting build uses picksplit function to
+-- find better partitioning for index records. This allows to
+-- build indices performing similarly to those produced by default
+-- method while still reducing index build time significantly.
 --
 -- To enable sortsupport:
 --   alter operator family gist_geometry_ops_2d using gist
@@ -836,10 +840,9 @@ CREATE OPERATOR CLASS gist_geometry_ops_2d
 --   alter operator family gist_geometry_ops_2d using gist
 --     drop function 11 (geometry);
 --
--- #if POSTGIS_PGSQL_VERSION >= 140
---	FUNCTION        11       geometry_gist_sortsupport_2d (internal),
--- #endif
---
+#if POSTGIS_PGSQL_VERSION >= 150
+	FUNCTION        11       geometry_gist_sortsupport_2d (internal),
+#endif
 	FUNCTION        8        geometry_gist_distance_2d (internal, geometry, int4),
 	FUNCTION        1        geometry_gist_consistent_2d (internal, geometry, int4),
 	FUNCTION        2        geometry_gist_union_2d (bytea, internal),

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

Summary of changes:
 NEWS                   |  1 +
 postgis/postgis.sql.in | 17 ++++++++++-------
 2 files changed, 11 insertions(+), 7 deletions(-)


hooks/post-receive
-- 
PostGIS