git.postgresql.org Git - users/c2main/postgres.git/commit

projects / users / c2main / postgres.git / commit

author	Peter Geoghegan <pg@bowt.ie>
	Thu, 17 Feb 2022 02:41:52 +0000 (18:41 -0800)
committer	Peter Geoghegan <pg@bowt.ie>
	Thu, 17 Feb 2022 02:41:52 +0000 (18:41 -0800)
commit	8f388f6f554b113f25a53fe3237238d2c58ed1eb
tree	2366a367511bb0dd101bd46a5a08428a215319cd	tree
parent	74388a1ac36d2f0206c5477eeddc636d7947a5a4	commit \| diff

Increase hash_mem_multiplier default to 2.0.

Double the default setting for hash_mem_multiplier, from 1.0 to 2.0.
This setting makes hash-based executor nodes use twice the usual
work_mem limit.

The PostgreSQL 15 release notes should have a compatibility note about
this change.

Author: Peter Geoghegan <pg@bowt.ie>
Discussion: https://postgr.es/m/CAH2-Wzndc_ROk6CY-bC6p9O53q974Y0Ey4WX8jcPbuTZYM4Q3A@mail.gmail.com

Cedric's Stuff

RSS Atom

doc/src/sgml/config.sgml		diff \| blob \| blame \| history
src/backend/utils/init/globals.c		diff \| blob \| blame \| history
src/backend/utils/misc/guc.c		diff \| blob \| blame \| history
src/backend/utils/misc/postgresql.conf.sample		diff \| blob \| blame \| history
src/test/regress/expected/groupingsets.out		diff \| blob \| blame \| history
src/test/regress/expected/join_hash.out		diff \| blob \| blame \| history
src/test/regress/expected/memoize.out		diff \| blob \| blame \| history
src/test/regress/sql/groupingsets.sql		diff \| blob \| blame \| history
src/test/regress/sql/join_hash.sql		diff \| blob \| blame \| history
src/test/regress/sql/memoize.sql		diff \| blob \| blame \| history