[postgis-tickets] [SCM] PostGIS branch master updated. 3.3.0rc2-225-g44e6da911

[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  44e6da911a55339d7e3f63b45351f77b06e2ff6b (commit)
      from  026b79776c0d0fb146b0d1adb9f29dceb5519b8c (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 44e6da911a55339d7e3f63b45351f77b06e2ff6b
Author: Paul Ramsey <pramsey at cleverelephant.ca>
Date:   Wed Oct 19 15:03:13 2022 -0700

    Reduce "high" and "medium" costs by a factor of two.
    Follows this conversation:
    https://lists.osgeo.org/pipermail/postgis-devel/2022-September/029818.html
    Very high costs are flipping some plans badly.
    Want to retain relatively large costs to promote parallel
    plans and other things that are "good" for geospatial,
    but walk the line carefully.
    
    Closes #5259

diff --git a/postgis/sqldefines.h.in b/postgis/sqldefines.h.in
index 5f814667e..462416e4d 100644
--- a/postgis/sqldefines.h.in
+++ b/postgis/sqldefines.h.in
@@ -25,8 +25,8 @@
 #if POSTGIS_PGSQL_VERSION >= 120
 #define _COST_DEFAULT COST 1
 #define _COST_LOW COST 50
-#define _COST_MEDIUM COST 500
-#define _COST_HIGH COST 10000
+#define _COST_MEDIUM COST 250
+#define _COST_HIGH COST 5000
 #else
 #define _COST_DEFAULT COST 1
 #define _COST_LOW COST 1

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

Summary of changes:
 postgis/sqldefines.h.in | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)


hooks/post-receive
-- 
PostGIS