pgsql-server/ oc/src/sgml/runtime.sgml rc/back ...

pgsql-server/ oc/src/sgml/runtime.sgml rc/back ...

CVSROOT:	/cvsroot
Module name:	pgsql-server
Changes by:	tgl@svr1.postgresql.org	04/01/23 19:54:21

Modified files:
	doc/src/sgml   : runtime.sgml 
	src/backend/optimizer/geqo: geqo_eval.c geqo_main.c geqo_pool.c 
	                            geqo_recombination.c 
	src/backend/utils/misc: guc.c postgresql.conf.sample 
	src/include/optimizer: geqo.h geqo_pool.h 

Log message:
	Revise GEQO planner to make use of some heuristic knowledge about SQL, namely
	that it's good to join where there are join clauses rather than where there
	are not.  Also enable it to generate bushy plans at need, so that it doesn't
	fail in the presence of multiple IN clauses containing sub-joins.  These
	changes appear to improve the behavior enough that we can substantially reduce
	the default pool size and generations count, thereby decreasing the runtime,
	and yet get as good or better plans as we were getting in 7.4.  Consequently,
	adjust the default GEQO parameters.  I also modified the way geqo_effort is
	used so that it affects both population size and number of generations;
	it's now useful as a single control to adjust the GEQO runtime-vs-plan-quality
	tradeoff.  Bump geqo_threshold to 12, since even with these changes GEQO
	seems to be slower than the regular planner at 11 relations.