Skip to main content
Version: 1.0.16

Memory Parameters

shared_buffers​

Numeric type (memory). Size of the shared memory pool (SBP), which directly affects database performance. Default value 128MB. It is recommended to set this to 25%~40% of system memory. This parameter can only be set at instance startup.

shared_buffers = 128MB  # (change requires restart)

huge_pages​

Enum type. Whether the shared memory pool uses huge pages. Available values: try (attempt to use, fall back if unavailable), on (force use), off (disable). Default value try. This parameter can only be set at instance startup.

huge_pages = try            # on, off, or try(change requires restart)

temp_buffers​

Numeric type (memory). Maximum memory for temporary buffers per session process, used to store temporary tables. Default value 8MB. This parameter can be set during runtime.

temp_buffers = 8MB            # min 800kB

work_mem​

Numeric type (memory). Maximum memory per session process for operations such as sorting and joining. Default value 4MB. It is recommended to increase this appropriately. This parameter can be set during runtime.

work_mem = 4MB                # min 64kB

hash_mem_multiplier​

Numeric type. Memory multiplier factor for hash table operations, calculated based on work_mem. Default value 2.0, range 1~1000.

hash_mem_multiplier = 2.0        # 1-1000.0 multiplier on hash table work_mem

maintenance_work_mem​

Numeric type (memory). Maximum memory used for maintenance operations (such as VACUUM, CREATE INDEX, etc.). Default value 64MB. This parameter can be set during runtime.

maintenance_work_mem = 64MB        # min 1MB

autovacuum_work_mem​

Numeric type (memory). Maximum memory available to each vacuum worker process. Default value -1, which means the value of maintenance_work_mem is used. This parameter can be set during runtime.

autovacuum_work_mem = -1        # min 1MB, or -1 to use maintenance_work_mem

dynamic_shared_memory_type​

Enum type. Implementation method for dynamic shared memory. Available values include posix, sysv, windows, mmap. The default value is automatically selected based on the operating system. This parameter can only be set at instance startup.

dynamic_shared_memory_type = posix    # the default is usually the first option
                                        # supported by the operating system:
                                        #   posix
                                        #   sysv
                                        #   windows
                                        #   mmap
                                        # (change requires restart)