19.11. Background Freezer #

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.