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

-- @Description Tests the basic behavior of (lazy) vacuum when called from utility mode
--
DROP TABLE IF EXISTS foo;
DROP
CREATE TABLE foo (a INT, b INT, c CHAR(128)) USING @amname@;
CREATE
CREATE INDEX foo_index ON foo(b);
CREATE
INSERT INTO foo SELECT i as a, 1 as b, 'hello world' as c FROM generate_series(1, 100) AS i;
INSERT 100

DELETE FROM foo WHERE a < 20;
DELETE 19
SELECT COUNT(*) FROM foo;
 count 
-------
 81    
(1 row)
0U: SELECT segno, state, case when tupcount = 0 then 'zero' when tupcount <= 5 then 'few' else 'many' end FROM gp_ao_or_aocs_seg('foo');
 segno | state | case 
-------+-------+------
 1     | 1     | many 
(1 row)
0U: VACUUM foo;
VACUUM
SELECT COUNT(*) FROM foo;
 count 
-------
 81    
(1 row)
0U: SELECT segno, state, case when tupcount = 0 then 'zero' when tupcount <= 5 then 'few' else 'many' end FROM gp_ao_or_aocs_seg('foo');
 segno | state | case 
-------+-------+------
 0     | 1     | many 
 1     | 2     | many 
(2 rows)