hash_mem_multiplier

A configuration parameter for computing the maximum amount of memory that hash-based operations can use

hash_mem_multiplier is a configuration parameter for computing the maximum amount of memory that hash-based operations can use.

hash_mem_multiplier was added in PostgreSQL 13.

Default

The default value for .hash_mem_multiplier is:

  • 2.0 (PostgreSQL 15 ~)
  • 1.0 (PostgreSQL 13 / 14)

Change history

Categories

GUC configuration item, Memory

See also

work_mem