Commit3228755

committed

Use BUFFER_USAGE_LIMIT to reduce needed test table size

Using the minimum BUFFER_USAGE_LIMIT value, we can make one of the pg_stat_iotest tables smaller while still causing reuses.Author: Melanie Plageman <melanieplageman@gmail.com>Discussion:https://postgr.es/m/CAAKRu_acc6iL4M3hvOTeztf_ZPpsB3Pqio5aVHgZ5q=Pi3BZKg@mail.gmail.com

1 parentb9a7a82 commit3228755Copy full SHA for 3228755

File tree

-4

lines changed

-4

lines changed

Lines changed: 4 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1396,11 +1396,13 @@ SET wal_skip_threshold = '1 kB';`
`1396`	`1396`	`SELECT sum(reuses) AS reuses, sum(reads) AS reads`
`1397`	`1397`	`FROM pg_stat_io WHERE context = 'vacuum' \gset io_sum_vac_strategy_before_`
`1398`	`1398`	`CREATE TABLE test_io_vac_strategy(a int, b int) WITH (autovacuum_enabled = 'false');`
`1399`		`-INSERT INTO test_io_vac_strategy SELECT i, i from generate_series(1,8000)i;`
	`1399`	`+INSERT INTO test_io_vac_strategy SELECT i, i from generate_series(1,4500)i;`
`1400`	`1400`	`-- Ensure that the next VACUUM will need to perform IO by rewriting the table`
`1401`	`1401`	`-- first with VACUUM (FULL).`
`1402`	`1402`	`VACUUM (FULL) test_io_vac_strategy;`
`1403`		`-VACUUM (PARALLEL 0) test_io_vac_strategy;`
	`1403`	`+-- Use the minimum BUFFER_USAGE_LIMIT to cause reuses with the smallest table`
	`1404`	`+-- possible.`
	`1405`	`+VACUUM (PARALLEL 0, BUFFER_USAGE_LIMIT 128) test_io_vac_strategy;`
`1404`	`1406`	`SELECT pg_stat_force_next_flush();`
`1405`	`1407`	`pg_stat_force_next_flush`
`1406`	`1408`	`--------------------------`

Lines changed: 4 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -690,11 +690,13 @@ SET wal_skip_threshold = '1 kB';`
`690`	`690`	`SELECTsum(reuses)AS reuses,sum(reads)AS reads`
`691`	`691`	`FROM pg_stat_ioWHERE context='vacuum' \gset io_sum_vac_strategy_before_`
`692`	`692`	`CREATETABLEtest_io_vac_strategy(aint, bint) WITH (autovacuum_enabled='false');`
`693`		`-INSERT INTO test_io_vac_strategySELECT i, ifrom generate_series(1,8000)i;`
	`693`	`+INSERT INTO test_io_vac_strategySELECT i, ifrom generate_series(1,4500)i;`
`694`	`694`	`-- Ensure that the next VACUUM will need to perform IO by rewriting the table`
`695`	`695`	`-- first with VACUUM (FULL).`
`696`	`696`	`VACUUM (FULL) test_io_vac_strategy;`
`697`		`-VACUUM (PARALLEL0) test_io_vac_strategy;`
	`697`	`+-- Use the minimum BUFFER_USAGE_LIMIT to cause reuses with the smallest table`
	`698`	`+-- possible.`
	`699`	`+VACUUM (PARALLEL0, BUFFER_USAGE_LIMIT128) test_io_vac_strategy;`
`698`	`700`	`SELECT pg_stat_force_next_flush();`
`699`	`701`	`SELECTsum(reuses)AS reuses,sum(reads)AS reads`
`700`	`702`	`FROM pg_stat_ioWHERE context='vacuum' \gset io_sum_vac_strategy_after_`

Comments

(0)