Increase hash_mem_multiplier default to 2.0.
Peter Geoghegan <pg@bowt.ie>
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
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/config.sgml | modified | +3 −4 |
| src/backend/utils/init/globals.c | modified | +1 −1 |
| src/backend/utils/misc/guc.c | modified | +1 −1 |
| src/backend/utils/misc/postgresql.conf.sample | modified | +1 −1 |
| src/test/regress/expected/groupingsets.out | modified | +2 −0 |
| src/test/regress/expected/join_hash.out | modified | +18 −0 |
| src/test/regress/expected/memoize.out | modified | +3 −1 |
| src/test/regress/sql/groupingsets.sql | modified | +2 −0 |
| src/test/regress/sql/join_hash.sql | modified | +18 −0 |
| src/test/regress/sql/memoize.sql | modified | +3 −1 |
Documentation touched
Discussion
- Time to increase hash_mem_multiplier default? 5 messages · 2022-01-17 → 2022-02-17