Commitbd19ab2

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 parent4553b96 commitbd19ab2Copy full SHA for bd19ab2

File tree

-6

lines changed

-6

lines changed

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -127,19 +127,19 @@ VACUUM (INDEX_CLEANUP FALSE) vaccluster;`
`127`	`127`	`VACUUM (INDEX_CLEANUP FALSE) vactst; -- index cleanup option is ignored if no indexes`
`128`	`128`	`VACUUM (INDEX_CLEANUP FALSE, FREEZE TRUE) vaccluster;`
`129`	`129`	`-- TRUNCATE option`
`130`		`-CREATE TABLE vac_truncate_test(i INT NOT NULL, j text)`
	`130`	`+CREATETEMPTABLE vac_truncate_test(i INT NOT NULL, j text)`
`131`	`131`	`WITH (vacuum_truncate=true, autovacuum_enabled=false);`
`132`	`132`	`INSERT INTO vac_truncate_test VALUES (1, NULL), (NULL, NULL);`
`133`	`133`	`ERROR: null value in column "i" violates not-null constraint`
`134`	`134`	`DETAIL: Failing row contains (null, null).`
`135`		`-VACUUM (TRUNCATE FALSE) vac_truncate_test;`
	`135`	`+VACUUM (TRUNCATE FALSE, DISABLE_PAGE_SKIPPING) vac_truncate_test;`
`136`	`136`	`SELECT pg_relation_size('vac_truncate_test') > 0;`
`137`	`137`	`?column?`
`138`	`138`	`----------`
`139`	`139`	`t`
`140`	`140`	`(1 row)`
`141`	`141`
`142`		`-VACUUM vac_truncate_test;`
	`142`	`+VACUUM(DISABLE_PAGE_SKIPPING)vac_truncate_test;`
`143`	`143`	`SELECT pg_relation_size('vac_truncate_test') = 0;`
`144`	`144`	`?column?`
`145`	`145`	`----------`

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -111,12 +111,12 @@ VACUUM (INDEX_CLEANUP FALSE) vactst; -- index cleanup option is ignored if no in`
`111`	`111`	`VACUUM (INDEX_CLEANUP FALSE, FREEZE TRUE) vaccluster;`
`112`	`112`
`113`	`113`	`-- TRUNCATE option`
`114`		`-CREATETABLEvac_truncate_test(iINTNOT NULL, jtext)`
	`114`	`+CREATETEMPTABLE vac_truncate_test(iINTNOT NULL, jtext)`
`115`	`115`	`WITH (vacuum_truncate=true, autovacuum_enabled=false);`
`116`	`116`	`INSERT INTO vac_truncate_testVALUES (1,NULL), (NULL,NULL);`
`117`		`-VACUUM (TRUNCATE FALSE) vac_truncate_test;`
	`117`	`+VACUUM (TRUNCATE FALSE, DISABLE_PAGE_SKIPPING) vac_truncate_test;`
`118`	`118`	`SELECT pg_relation_size('vac_truncate_test')>0;`
`119`		`-VACUUM vac_truncate_test;`
	`119`	`+VACUUM(DISABLE_PAGE_SKIPPING)vac_truncate_test;`
`120`	`120`	`SELECT pg_relation_size('vac_truncate_test')=0;`
`121`	`121`	`VACUUM (TRUNCATE FALSE, FULL TRUE) vac_truncate_test;`
`122`	`122`	`DROPTABLE vac_truncate_test;`

Comments

(0)