Skip to content
Snippets Groups Projects
vacuum-concurrent-drop.spec 1.24 KiB
Newer Older
# Test for log messages emitted by VACUUM and ANALYZE when a specified
# relation is concurrently dropped.
#
# This also verifies that log messages are not emitted for concurrently
# dropped relations that were not specified in the VACUUM or ANALYZE
# command.

setup
{
	CREATE TABLE parted (a INT) PARTITION BY LIST (a);
	CREATE TABLE part1 PARTITION OF parted FOR VALUES IN (1);
	CREATE TABLE part2 PARTITION OF parted FOR VALUES IN (2);
	DROP TABLE IF EXISTS parted;
step "vac_specified"		{ VACUUM part1, part2; }
step "vac_all_parts"		{ VACUUM parted; }
step "analyze_specified"	{ ANALYZE part1, part2; }
step "analyze_all_parts"	{ ANALYZE parted; }
step "vac_analyze_specified"	{ VACUUM ANALYZE part1, part2; }
step "vac_analyze_all_parts"	{ VACUUM ANALYZE parted; }

permutation "lock" "vac_specified" "drop_and_commit"
permutation "lock" "vac_all_parts" "drop_and_commit"
permutation "lock" "analyze_specified" "drop_and_commit"
permutation "lock" "analyze_all_parts" "drop_and_commit"
permutation "lock" "vac_analyze_specified" "drop_and_commit"
permutation "lock" "vac_analyze_all_parts" "drop_and_commit"