[postgis-tickets] [SCM] PostGIS branch master updated. 3.2.0beta2-15-gf55de7f52

git at osgeo.org git at osgeo.org
Fri Dec 3 20:21:36 PST 2021


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  f55de7f52d009bc9467a38ee04e5a16e17e2ba72 (commit)
      from  d8976c0d2f6b8906b583f24e98fba2ef92fb1277 (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 f55de7f52d009bc9467a38ee04e5a16e17e2ba72
Author: Regina Obe <lr at pcorp.us>
Date:   Fri Dec 3 23:21:31 2021 -0500

    Prepping for PostGIS 3.2.0beta3

diff --git a/NEWS b/NEWS
index aec161b86..9ee0e3422 100644
--- a/NEWS
+++ b/NEWS
@@ -1,15 +1,36 @@
 PostGIS 3.2.0beta3
-2021/xx/xx
+2021/12/04
 This version requires PostgreSQL 9.6 or higher, GEOS 3.6 or higher, and Proj 4.9+
 Additional features are enabled if you are running GEOS 3.9+
 (and ST_MakeValid enhancements with 3.10+),
 Proj 6.1+, and PostgreSQL 14+.
+Due to some query performance degradation
+with the new fast index build that requires PG14,
+we have decided to disable the feature by default
+until we get more user testing
+as to the true impact of real-world queries.
+If you are running PG14+, you can reenable it by doing
+
+ALTER OPERATOR FAMILY gist_geometry_ops_2d USING gist
+     ADD FUNCTION 11 (geometry)
+     geometry_gist_sortsupport_2d (internal);
+
+To revert the change:
+   ALTER OPERATOR FAMILY gist_geometry_ops_2d using gist
+     DROP FUNCTION 11 (geometry);
+
+and then reindex your gist indexes.
+
 Changes since PostGIS 3.2.0beta2 release:
-  * Fixes *
+  * Breaking changes / fixes *
   - #5028, ST_AsFlatGeobuf crashes on mixed geometry input
+    (Björn Harrtell)
   - #5029, ST_AsFlatGeobuf indexed output corruption
-  - #5014, Crash on ST_TableFromFlatGeobuf
-  * Enhancements *
+    (Björn Harrtell)
+  - #5014, Crash on ST_TableFromFlatGeobuf (Björn Harrtell)
+  - Rename ST_TableFromFlatGeobuf to ST_FromFlatGeobufToTable
+    (Björn Harrtell)
+  - PG14 fast index building disabled by default. (Paul Ramsey)
 
 PostGIS 3.2.0beta2
 2021/11/26
diff --git a/README.postgis b/README.postgis
index 6e51289dc..c31624ee7 100644
--- a/README.postgis
+++ b/README.postgis
@@ -1,8 +1,8 @@
 PostGIS - Geographic Information Systems Extensions to PostgreSQL
 =================================================================
 
-:Version: 3.2.0beta2
-:Date: 2021-11-26
+:Version: 3.2.0beta3
+:Date: 2021-12-04
 :Website: https://postgis.net
 
 This distribution contains a module which implements GIS simple features, ties
diff --git a/Version.config b/Version.config
index 843963a1e..78ef196d7 100644
--- a/Version.config
+++ b/Version.config
@@ -5,7 +5,7 @@
 
 POSTGIS_MAJOR_VERSION=3
 POSTGIS_MINOR_VERSION=2
-POSTGIS_MICRO_VERSION=0dev
+POSTGIS_MICRO_VERSION=0beta3
 
 # Liblwgeom interface versioning, reset to 0:0:0 (cur:age:rev)
 # when changing POSTGIS_MINOR_VERSION
diff --git a/doc/release_notes.xml b/doc/release_notes.xml
index 923ee1cae..ee66b7aa0 100644
--- a/doc/release_notes.xml
+++ b/doc/release_notes.xml
@@ -2,6 +2,45 @@
 <appendix id="release_notes">
   <title>Appendix</title>
     <subtitle>Release Notes</subtitle>
+
+    <sect1>
+        <title>PostGIS 3.2.0beta3</title>
+        <para>2021/12/04</para>
+        <para>This version requires PostgreSQL 9.6 or higher, GEOS 3.6 or higher, and Proj 4.9+
+Additional features are enabled if you are running GEOS 3.9+
+(and ST_MakeValid enhancements with 3.10+),
+Proj 6.1+, and PostgreSQL 14+.</para>
+    <para>Due to some query performance degradation
+    with the new PG14 fast index build ,
+    we have decided to disable the feature by default
+    until we get more user testing
+    as to the true impact of real-world queries.
+    If you are running PG14+, you can reenable it by doing:</para>
+
+    <programlisting>ALTER OPERATOR FAMILY gist_geometry_ops_2d USING gist
+        ADD FUNCTION 11 (geometry)
+        geometry_gist_sortsupport_2d (internal);
+    </programlisting>
+    <para>To revert the change:</para>
+    <programlisting>ALTER OPERATOR FAMILY gist_geometry_ops_2d using gist
+     DROP FUNCTION 11 (geometry);</programlisting>
+
+    <para>and then reindex your gist indexes</para>
+
+    <para>Changes since PostGIS 3.2.0beta2 release:</para>
+    <simplesect>
+        <title>Breaking changes / fixes</title>
+        <para>5028, ST_AsFlatGeobuf crashes on mixed geometry input
+            (Björn Harrtell)</para>
+        <para>5029, ST_AsFlatGeobuf indexed output corruption
+            (Björn Harrtell)</para>
+        <para>5014, Crash on ST_TableFromFlatGeobuf (Björn Harrtell)</para>
+        <para>Rename ST_TableFromFlatGeobuf to ST_FromFlatGeobufToTable
+                (Björn Harrtell)</para>
+         <para>PG14 fast index building disabled by default. (Paul Ramsey)</para>
+    </simplesect>
+    </sect1>
+
     <sect1>
         <title>Release 3.2.0beta2</title>
         <para>Release date: 2021/11/26</para>
@@ -12,7 +51,7 @@ Proj 6.1+, and PostgreSQL 14+.
 
 Changes since PostGIS 3.2.0beta1 release:</para>
         <simplesect>
-            <title> Breaking changes / fixes</title>
+            <title>Breaking changes / fixes</title>
             <para>5016, loader (shp2pgsq): Respect LDFLAGS (Greg Troxel)</para>
             <para>5005, ST_AsFlatGeoBuf crashes on tables when geometry
                     column is not the first column (Björn Harrtell)</para>

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

Summary of changes:
 NEWS                  | 29 +++++++++++++++++++++++++----
 README.postgis        |  4 ++--
 Version.config        |  2 +-
 doc/release_notes.xml | 41 ++++++++++++++++++++++++++++++++++++++++-
 4 files changed, 68 insertions(+), 8 deletions(-)


hooks/post-receive
-- 
PostGIS


More information about the postgis-tickets mailing list