These settings control the behavior of background freezer. Refer to Section 24.2 for more information.
enable_background_freezer (boolean)
#
Enables or disables sending messages to the background freezer worker
using a UDP socket. This configuration parameter can be set either in the
postgresql.conf file or in a session by superusers.
The default value is off.
bgfreezer_pages_per_rel_to_clean (integer)
#
Sets the number of pages that the background freezer worker accumulates
in a queue for each table to start vacuuming. For example, if
bgfreezer_pages_per_rel_to_clean=128,
the worker accumulates at least 128 pages in a queue and starts processing
them after the transaction is completed. When set to 0,
queued pages start to be processed at the end of each transaction. This
configuration parameter can be set either in the
postgresql.conf file or by sending the
SIGHUP signal to the main server process. The
default value is 128.
bgfreezer_max_pages_per_rel (integer)
#
Sets the maximum number of pages that can be queued for vacuuming per
table. When this number is reached, page accumulation stops and new
pages evict old pages from the queue. This configuration parameter can
be set either in the postgresql.conf file or by
sending the SIGHUP signal to the main server
process. The default value is 32768.