src/test/singlenode_isolation2/output/uao/insert_while_vacuum.source

-- @Description Ensures that an insert during a vacuum operation is ok
--
DROP TABLE IF EXISTS ao;
DROP
CREATE TABLE ao (a INT) USING @amname@;
CREATE
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000
insert into ao select generate_series(1,1000);
INSERT 1000

DELETE FROM ao WHERE a < 128;
DELETE 2667
2>: VACUUM ao;  <waiting ...>
4: BEGIN;
BEGIN
4: insert into ao select generate_series(1001,2000);insert into ao select generate_series(1001,2000);insert into ao select generate_series(1001,2000);insert into ao select generate_series(1001,2000);insert into ao select generate_series(1001,2000);insert into ao select generate_series(1001,2000);insert into ao select generate_series(1001,2000);insert into ao select generate_series(1001,2000);insert into ao select generate_series(1001,2000);insert into ao select generate_series(1001,2000);insert into ao select generate_series(1001,2000);insert into ao select generate_series(1001,2000);insert into ao select generate_series(1001,2000);insert into ao select generate_series(1001,2000);insert into ao select generate_series(1001,2000);insert into ao select generate_series(1001,2000);insert into ao select generate_series(1001,2000);insert into ao select generate_series(1001,2000);insert into ao select generate_series(1001,2000);insert into ao select generate_series(1001,2000);COMMIT;
INSERT
2<:  <... completed>
VACUUM
3: SELECT COUNT(*) FROM ao WHERE a = 1500;
 count 
-------
 20    
(1 row)
4: INSERT INTO ao VALUES (0);
INSERT 1