From 4ff695b17d32a9c330952192dbc789d31a5e2f5e Mon Sep 17 00:00:00 2001 From: Alvaro Herrera Date: Fri, 3 Apr 2015 11:55:50 -0300 Subject: Add log_min_autovacuum_duration per-table option This is useful to control autovacuum log volume, for situations where monitoring only a set of tables is necessary. Author: Michael Paquier Reviewed by: A team led by Naoya Anzai (also including Akira Kurosawa, Taiki Kondo, Huong Dangminh), Fujii Masao. --- doc/src/sgml/ref/create_table.sgml | 16 +++++++++++++--- 1 file changed, 13 insertions(+), 3 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index 324d59371a7..be7ebd5f54f 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -881,9 +881,9 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXI toast., which can be used to control the behavior of the table's secondary TOAST table, if any (see for more information about TOAST). - Note that the TOAST table inherits the - autovacuum_* values from its parent table, if there are - no toast.autovacuum_* settings set. + Note that the TOAST table uses the parameter values defined for + the main table, for each parameter applicable to TOAST tables and + for which no value is set in the TOAST table itself. @@ -1060,6 +1060,15 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXI + + log_autovacuum_min_duration, toast.log_autovacuum_min_duration (integer) + + + Custom parameter. + + + + user_catalog_table (boolean) @@ -1067,6 +1076,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXI Declare a table as an additional catalog table, e.g. for the purpose of logical replication. See for details. + This parameter cannot be set for TOAST tables. -- cgit v1.2.3