Commitf784fcd

committed

Try to stabilize vacuum test.

As commitsb700f96 and3414099 did for the reloptions test, makesure VACUUM can always truncate the table as expected.Back-patch to 12, where vacuum_truncate arrived.Discussion:https://postgr.es/m/CAD21AoCNoWjYkdEtr%2BVDoF9v__V905AedKZ9iF%3DArgCtrbxZqw%40mail.gmail.com

1 parentf183e23 commitf784fcdCopy full SHA for f784fcd

File tree

-6

lines changed

-6

lines changed

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -163,19 +163,19 @@ VACUUM (INDEX_CLEANUP FALSE) vaccluster;`
`163`	`163`	`VACUUM (INDEX_CLEANUP FALSE) vactst; -- index cleanup option is ignored if no indexes`
`164`	`164`	`VACUUM (INDEX_CLEANUP FALSE, FREEZE TRUE) vaccluster;`
`165`	`165`	`-- TRUNCATE option`
`166`		`-CREATE TABLE vac_truncate_test(i INT NOT NULL, j text)`
	`166`	`+CREATETEMPTABLE vac_truncate_test(i INT NOT NULL, j text)`
`167`	`167`	`WITH (vacuum_truncate=true, autovacuum_enabled=false);`
`168`	`168`	`INSERT INTO vac_truncate_test VALUES (1, NULL), (NULL, NULL);`
`169`	`169`	`ERROR: null value in column "i" of relation "vac_truncate_test" violates not-null constraint`
`170`	`170`	`DETAIL: Failing row contains (null, null).`
`171`		`-VACUUM (TRUNCATE FALSE) vac_truncate_test;`
	`171`	`+VACUUM (TRUNCATE FALSE, DISABLE_PAGE_SKIPPING) vac_truncate_test;`
`172`	`172`	`SELECT pg_relation_size('vac_truncate_test') > 0;`
`173`	`173`	`?column?`
`174`	`174`	`----------`
`175`	`175`	`t`
`176`	`176`	`(1 row)`
`177`	`177`
`178`		`-VACUUM vac_truncate_test;`
	`178`	`+VACUUM(DISABLE_PAGE_SKIPPING)vac_truncate_test;`
`179`	`179`	`SELECT pg_relation_size('vac_truncate_test') = 0;`
`180`	`180`	`?column?`
`181`	`181`	`----------`

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -145,12 +145,12 @@ VACUUM (INDEX_CLEANUP FALSE) vactst; -- index cleanup option is ignored if no in`
`145`	`145`	`VACUUM (INDEX_CLEANUP FALSE, FREEZE TRUE) vaccluster;`
`146`	`146`
`147`	`147`	`-- TRUNCATE option`
`148`		`-CREATETABLEvac_truncate_test(iINTNOT NULL, jtext)`
	`148`	`+CREATETEMPTABLE vac_truncate_test(iINTNOT NULL, jtext)`
`149`	`149`	`WITH (vacuum_truncate=true, autovacuum_enabled=false);`
`150`	`150`	`INSERT INTO vac_truncate_testVALUES (1,NULL), (NULL,NULL);`
`151`		`-VACUUM (TRUNCATE FALSE) vac_truncate_test;`
	`151`	`+VACUUM (TRUNCATE FALSE, DISABLE_PAGE_SKIPPING) vac_truncate_test;`
`152`	`152`	`SELECT pg_relation_size('vac_truncate_test')>0;`
`153`		`-VACUUM vac_truncate_test;`
	`153`	`+VACUUM(DISABLE_PAGE_SKIPPING)vac_truncate_test;`
`154`	`154`	`SELECT pg_relation_size('vac_truncate_test')=0;`
`155`	`155`	`VACUUM (TRUNCATE FALSE, FULL TRUE) vac_truncate_test;`
`156`	`156`	`DROPTABLE vac_truncate_test;`

Comments

(0)