From 6587818542e79012276dcfedb2f97e3522ee5e9b Mon Sep 17 00:00:00 2001 From: Heikki Linnakangas Date: Fri, 16 Jan 2009 13:27:24 +0000 Subject: Add vacuum_freeze_table_age GUC option, to control when VACUUM should ignore the visibility map and scan the whole table, to advance relfrozenxid. --- src/backend/utils/misc/postgresql.conf.sample | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'src/backend/utils/misc/postgresql.conf.sample') diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index 977e13e0aff..a874b4541db 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -413,7 +413,8 @@ #default_transaction_read_only = off #session_replication_role = 'origin' #statement_timeout = 0 # 0 is disabled -#vacuum_freeze_min_age = 100000000 +#vacuum_freeze_min_age = 50000000 +#vacuum_freeze_table_age = 150000000 #xmlbinary = 'base64' #xmloption = 'content' -- cgit v1.2.3