Commit383f222

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 parent5b29a9f commit383f222Copy full SHA for 383f222

File tree

-6

lines changed

-6

lines changed

Lines changed: 3 additions & 3 deletions

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

Lines changed: 3 additions & 3 deletions

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

Comments

(0)