[postgis-tickets] [SCM] PostGIS branch master updated. 3.2.0beta2-14-gd8976c0d2

[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  d8976c0d2f6b8906b583f24e98fba2ef92fb1277 (commit)
      from  f7bc711c90d18e273b6254ee0a4c92caddbc9eeb (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 d8976c0d2f6b8906b583f24e98fba2ef92fb1277
Author: Paul Ramsey <pramsey at cleverelephant.ca>
Date:   Fri Dec 3 11:17:03 2021 -0800

    Remove geometry_gist_sortsupport_2d from the default operator class
    for geometry. Sort support for the GIST 2D geometry index will
    allow much faster index building (5x), but at the expense of query
    efficiency (0-50%).
    
    To enable sort support, create the extension as usual, then:
    
       alter operator family gist_geometry_ops_2d using gist
         add function 11 (geometry)
         geometry_gist_sortsupport_2d (internal);
    
    To remove sort support:
    
       alter operator family gist_geometry_ops_2d using gist
         drop function 11 (geometry);

diff --git a/postgis/postgis.sql.in b/postgis/postgis.sql.in
index 9b992549f..f54bf20cc 100644
--- a/postgis/postgis.sql.in
+++ b/postgis/postgis.sql.in
@@ -801,10 +801,24 @@ CREATE OPERATOR CLASS gist_geometry_ops_2d
 	OPERATOR        12       |&> ,
 	OPERATOR        13       <-> FOR ORDER BY pg_catalog.float_ops,
 	OPERATOR        14       <#> FOR ORDER BY pg_catalog.float_ops,
-#if POSTGIS_PGSQL_VERSION >= 140
-	-- Availability: 3.2.0
-	FUNCTION        11       geometry_gist_sortsupport_2d (internal),
-#endif
+--
+-- 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.
+--
+-- To enable sortsupport:
+--   alter operator family gist_geometry_ops_2d using gist
+--     add function 11 (geometry)
+--     geometry_gist_sortsupport_2d (internal);
+--
+-- To remove sortsupport:
+--   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
+--
 	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:
 postgis/postgis.sql.in | 22 ++++++++++++++++++----
 1 file changed, 18 insertions(+), 4 deletions(-)


hooks/post-receive
-- 
PostGIS