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/parser | |
parent | 10c70b86023001dc6d9028737afc97850b86e58f (diff) |
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/parser')
-rw-r--r-- | src/backend/parser/gram.y | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/src/backend/parser/gram.y b/src/backend/parser/gram.y index 1d1e105c74e..c90743a1017 100644 --- a/src/backend/parser/gram.y +++ b/src/backend/parser/gram.y @@ -11,7 +11,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/parser/gram.y,v 2.567 2006/10/13 21:43:19 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/parser/gram.y,v 2.568 2006/11/05 22:42:09 tgl Exp $ * * HISTORY * AUTHOR DATE MAJOR EVENT @@ -5158,7 +5158,7 @@ VacuumStmt: VACUUM opt_full opt_freeze opt_verbose n->vacuum = true; n->analyze = false; n->full = $2; - n->freeze = $3; + n->freeze_min_age = $3 ? 0 : -1; n->verbose = $4; n->relation = NULL; n->va_cols = NIL; @@ -5170,7 +5170,7 @@ VacuumStmt: VACUUM opt_full opt_freeze opt_verbose n->vacuum = true; n->analyze = false; n->full = $2; - n->freeze = $3; + n->freeze_min_age = $3 ? 0 : -1; n->verbose = $4; n->relation = $5; n->va_cols = NIL; @@ -5181,7 +5181,7 @@ VacuumStmt: VACUUM opt_full opt_freeze opt_verbose VacuumStmt *n = (VacuumStmt *) $5; n->vacuum = true; n->full = $2; - n->freeze = $3; + n->freeze_min_age = $3 ? 0 : -1; n->verbose |= $4; $$ = (Node *)n; } @@ -5194,7 +5194,7 @@ AnalyzeStmt: n->vacuum = false; n->analyze = true; n->full = false; - n->freeze = false; + n->freeze_min_age = -1; n->verbose = $2; n->relation = NULL; n->va_cols = NIL; @@ -5206,7 +5206,7 @@ AnalyzeStmt: n->vacuum = false; n->analyze = true; n->full = false; - n->freeze = false; + n->freeze_min_age = -1; n->verbose = $2; n->relation = $3; n->va_cols = $4; |