Wiki / Configuration Parameters

Specifies the amount of memory that should be allocated at server startup for use by parallel queries. When this memory region is insufficient or exhausted by concurrent queries, new parallel queries try to allocate extra shared memory temporarily from the operating system using the method configured with dynamic_shared_memory_type, which may be slower due to memory management overheads. Memory that is allocated at startup with min_dynamic_shared_memory is affected by the huge_pages setting on operating systems where that is supported, and may be more likely to benefit from larger pages on operating systems where that is managed automatically. The default value is 0 (none). This parameter can only be set at server start.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

boot val

0

category

Resource Usage / Memory

context

postmaster

documented

true

enumvals

Unknown

extra desc

Unknown

lang

en

max val

2147483647

metadata version

18

min val

0

name

min_dynamic_shared_memory

short desc

Amount of dynamic shared memory reserved at startup.

source

pg-settings-source-snapshot

unit

MB

vartype

integer