diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2006-11-05 22:42:10 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2006-11-05 22:42:10 +0000 |
| commit | 48188e1621bb6711e7d092bee48523b18cd80177 (patch) | |
| tree | 524459ab58f8740a23efa7b7b521833646c678ba /src/backend/utils/misc/guc.c | |
| parent | 10c70b86023001dc6d9028737afc97850b86e58f (diff) | |
| download | postgresql-48188e1621bb6711e7d092bee48523b18cd80177.tar.gz postgresql-48188e1621bb6711e7d092bee48523b18cd80177.zip | |
Fix recently-understood problems with handling of XID freezing, particularly
in PITR scenarios. We now WAL-log the replacement of old XIDs with
FrozenTransactionId, so that such replacement is guaranteed to propagate to
PITR slave databases. Also, rather than relying on hint-bit updates to be
preserved, pg_clog is not truncated until all instances of an XID are known to
have been replaced by FrozenTransactionId. Add new GUC variables and
pg_autovacuum columns to allow management of the freezing policy, so that
users can trade off the size of pg_clog against the amount of freezing work
done. Revise the already-existing code that forces autovacuum of tables
approaching the wraparound point to make it more bulletproof; also, revise the
autovacuum logic so that anti-wraparound vacuuming is done per-table rather
than per-database. initdb forced because of changes in pg_class, pg_database,
and pg_autovacuum catalogs. Heikki Linnakangas, Simon Riggs, and Tom Lane.
Diffstat (limited to 'src/backend/utils/misc/guc.c')
| -rw-r--r-- | src/backend/utils/misc/guc.c | 20 |
1 files changed, 19 insertions, 1 deletions
diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c index f0ff66fa66a..5bbf89da5bd 100644 --- a/src/backend/utils/misc/guc.c +++ b/src/backend/utils/misc/guc.c @@ -10,7 +10,7 @@ * Written by Peter Eisentraut <peter_e@gmx.net>. * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.357 2006/10/19 18:32:47 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.358 2006/11/05 22:42:09 tgl Exp $ * *-------------------------------------------------------------------- */ @@ -1331,6 +1331,15 @@ static struct config_int ConfigureNamesInt[] = }, { + {"vacuum_freeze_min_age", PGC_USERSET, CLIENT_CONN_STATEMENT, + gettext_noop("Minimum age at which VACUUM should freeze a table row."), + NULL + }, + &vacuum_freeze_min_age, + 100000000, 0, 1000000000, NULL, NULL + }, + + { {"max_fsm_relations", PGC_POSTMASTER, RESOURCES_FSM, gettext_noop("Sets the maximum number of tables and indexes for which free space is tracked."), NULL @@ -1576,6 +1585,15 @@ static struct config_int ConfigureNamesInt[] = &autovacuum_anl_thresh, 250, 0, INT_MAX, NULL, NULL }, + { + /* see varsup.c for why this is PGC_POSTMASTER not PGC_SIGHUP */ + {"autovacuum_freeze_max_age", PGC_POSTMASTER, AUTOVACUUM, + gettext_noop("Age at which to autovacuum a table to prevent transacion ID wraparound."), + NULL + }, + &autovacuum_freeze_max_age, + 200000000, 100000000, 2000000000, NULL, NULL + }, { {"tcp_keepalives_idle", PGC_USERSET, CLIENT_CONN_OTHER, |