Commit779972e

committed

Disable autovacuum for tables in stats import tests.

While we haven't observed any test instability, it seems like a goodidea to disable autovacuum during the stats import tests.Author: Corey HuinkerDiscussion:https://postgr.es/m/CADkLM=fajh1Lpcyr_XsMmq-9Z=SGk-u+_Zeac7Pt0RAN3uiVCg@mail.gmail.com

1 parentb391d88 commit779972eCopy full SHA for 779972e

File tree

-4

lines changed

-4

lines changed

Lines changed: 3 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -11,7 +11,7 @@ CREATE TABLE stats_import.test(`
`11`	`11`	`comp stats_import.complex_type,`
`12`	`12`	`arange int4range,`
`13`	`13`	`tags text[]`
`14`		`-);`
	`14`	`+) WITH (autovacuum_enabled = false);`
`15`	`15`	`-- starting stats`
`16`	`16`	`SELECT relpages, reltuples, relallvisible`
`17`	`17`	`FROM pg_class`
`@@ -139,7 +139,8 @@ DETAIL: This operation is not supported for views.`
`139`	`139`	`CREATE TABLE stats_import.part_parent ( i integer ) PARTITION BY RANGE(i);`
`140`	`140`	`CREATE TABLE stats_import.part_child_1`
`141`	`141`	`PARTITION OF stats_import.part_parent`
`142`		`- FOR VALUES FROM (0) TO (10);`
	`142`	`+ FOR VALUES FROM (0) TO (10)`
	`143`	`+ WITH (autovacuum_enabled = false);`
`143`	`144`	`ANALYZE stats_import.part_parent;`
`144`	`145`	`SELECT relpages`
`145`	`146`	`FROM pg_class`

Lines changed: 3 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -13,7 +13,7 @@ CREATE TABLE stats_import.test(`
`13`	`13`	`compstats_import.complex_type,`
`14`	`14`	`arange int4range,`
`15`	`15`	`tagstext[]`
`16`		`-);`
	`16`	`+) WITH (autovacuum_enabled= false);`
`17`	`17`
`18`	`18`	`-- starting stats`
`19`	`19`	`SELECT relpages, reltuples, relallvisible`
`@@ -99,7 +99,8 @@ SELECT`
`99`	`99`	`CREATETABLEstats_import.part_parent ( iinteger ) PARTITION BY RANGE(i);`
`100`	`100`	`CREATETABLEstats_import.part_child_1`
`101`	`101`	`PARTITION OFstats_import.part_parent`
`102`		`- FORVALUESFROM (0) TO (10);`
	`102`	`+ FORVALUESFROM (0) TO (10)`
	`103`	`+ WITH (autovacuum_enabled= false);`
`103`	`104`
`104`	`105`	`ANALYZEstats_import.part_parent;`
`105`	`106`

Comments

(0)