/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
src/test/isolation/specs/vacuum-concurrent-drop.spec
45 строк
1 KB
Tom Lane
Allow non-quoted identifiers as isolation test session/step names.
24 июн 2021, 01:41
24 июн 2021, 01:41
a443c1b
Код
Авторство
О чём код?
# 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); } teardown { DROP TABLE IF EXISTS parted; } session s1 step lock { BEGIN; LOCK part1 IN SHARE MODE; } step drop_and_commit { DROP TABLE part2; COMMIT; } session s2 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