Commitb9dd162

committed

Try to stabilize reloptions test, again.

Since the test requires reproducible behavior from VACUUM, and sinceDISABLE_PAGE_SKIPPING doesn't actually disable all forms of pageskipping, let's use a temporary table to avoid contention.Back-patch to 12, like commit3414099.Discussion:https://postgr.es/m/20220120052404.sonrhq3f3qgplpzj%40alap3.anarazel.de

1 parenta9009f5 commitb9dd162Copy full SHA for b9dd162

File tree

-2

lines changed

-2

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -89,7 +89,7 @@ ALTER TABLE reloptions_test RESET (fillfactor=12);`
`89`	`89`	`ERROR: RESET must not include values for parameters`
`90`	`90`	`-- Test vacuum_truncate option`
`91`	`91`	`DROP TABLE reloptions_test;`
`92`		`-CREATE TABLE reloptions_test(i INT NOT NULL, j text)`
	`92`	`+CREATETEMPTABLE reloptions_test(i INT NOT NULL, j text)`
`93`	`93`	`WITH (vacuum_truncate=false,`
`94`	`94`	`toast.vacuum_truncate=false,`
`95`	`95`	`autovacuum_enabled=false);`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -55,7 +55,7 @@ ALTER TABLE reloptions_test RESET (fillfactor=12);`
`55`	`55`	`-- Test vacuum_truncate option`
`56`	`56`	`DROPTABLE reloptions_test;`
`57`	`57`
`58`		`-CREATETABLEreloptions_test(iINTNOT NULL, jtext)`
	`58`	`+CREATETEMPTABLE reloptions_test(iINTNOT NULL, jtext)`
`59`	`59`	`WITH (vacuum_truncate=false,`
`60`	`60`	`toast.vacuum_truncate=false,`
`61`	`61`	`autovacuum_enabled=false);`

Comments

(0)