Re-Align *_freeze_max_age reloption limits with corresponding GUC limits.

anarazel · anarazel · commit 0577821b5725 · 2015-10-05T11:56:58.000+02:00
In 020235a I lowered the autovacuum_*freeze_max_age minimums to allow for easier testing of wraparounds. I did not touch the corresponding per-table limits. While those don't matter for the purpose of wraparound, it seems more consistent to lower them as well. It's noteworthy that the previous reloption lower limit for autovacuum_multixact_freeze_max_age was too high by one magnitude, even before 020235a. Discussion: 26377.1443105453@sss.pgh.pa.us Backpatch: back to 9.0 (in parts), like the prior patch
diff --git a/src/backend/access/common/reloptions.c b/src/backend/access/common/reloptions.c
@@ -185,15 +185,15 @@ static relopt_int intRelOpts[] =
 			"Age at which to autovacuum a table to prevent transaction ID wraparound",
 			RELOPT_KIND_HEAP | RELOPT_KIND_TOAST
 		},
-		-1, 100000000, 2000000000
+		-1, 100000, 2000000000
 	},
 	{
 		{
 			"autovacuum_multixact_freeze_max_age",
 			"Multixact age at which to autovacuum a table to prevent multixact wraparound",
 			RELOPT_KIND_HEAP | RELOPT_KIND_TOAST
 		},
-		-1, 100000000, 2000000000
+		-1, 10000, 2000000000
 	},
 	{
 		{

Original file line number	Diff line number	Diff line change
`@@ -185,15 +185,15 @@ static relopt_int intRelOpts[] =`
`185`	`185`	`"Age at which to autovacuum a table to prevent transaction ID wraparound",`
`186`	`186`	`RELOPT_KIND_HEAP \| RELOPT_KIND_TOAST`
`187`	`187`	`},`
`188`		`- -1, 100000000, 2000000000`
	`188`	`+ -1, 100000, 2000000000`
`189`	`189`	`},`
`190`	`190`	`{`
`191`	`191`	`{`
`192`	`192`	`"autovacuum_multixact_freeze_max_age",`
`193`	`193`	`"Multixact age at which to autovacuum a table to prevent multixact wraparound",`
`194`	`194`	`RELOPT_KIND_HEAP \| RELOPT_KIND_TOAST`
`195`	`195`	`},`
`196`		`- -1, 100000000, 2000000000`
	`196`	`+ -1, 10000, 2000000000`
`197`	`197`	`},`
`198`	`198`	`{`
`199`	`199`	`{`