diff options
Diffstat (limited to 'src/test/isolation/expected/vacuum-reltuples.out')
-rw-r--r-- | src/test/isolation/expected/vacuum-reltuples.out | 62 |
1 files changed, 62 insertions, 0 deletions
diff --git a/src/test/isolation/expected/vacuum-reltuples.out b/src/test/isolation/expected/vacuum-reltuples.out new file mode 100644 index 00000000000..ee3adf58050 --- /dev/null +++ b/src/test/isolation/expected/vacuum-reltuples.out @@ -0,0 +1,62 @@ +Parsed test spec with 2 sessions + +starting permutation: modify vac stats +step modify: + insert into smalltbl select max(id)+1 from smalltbl; + delete from smalltbl where id in (select min(id) from smalltbl); + +step vac: + vacuum smalltbl; + +step stats: + select relpages, reltuples from pg_class + where oid='smalltbl'::regclass; + +relpages reltuples + +1 20 + +starting permutation: modify open fetch1 vac close stats +step modify: + insert into smalltbl select max(id)+1 from smalltbl; + delete from smalltbl where id in (select min(id) from smalltbl); + +step open: + begin; + declare c1 cursor for select * from smalltbl; + +step fetch1: + fetch next from c1; + +id + +2 +step vac: + vacuum smalltbl; + +step close: + commit; + +step stats: + select relpages, reltuples from pg_class + where oid='smalltbl'::regclass; + +relpages reltuples + +1 20 + +starting permutation: modify vac stats +step modify: + insert into smalltbl select max(id)+1 from smalltbl; + delete from smalltbl where id in (select min(id) from smalltbl); + +step vac: + vacuum smalltbl; + +step stats: + select relpages, reltuples from pg_class + where oid='smalltbl'::regclass; + +relpages reltuples + +1 20 |