| -- @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) |
| 2U: VACUUM foo; |
| VACUUM |
| SELECT COUNT(*) FROM foo; |
| count |
| ------- |
| 81 |
| (1 row) |
| 2U: SELECT segno, tupcount FROM gp_ao_or_aocs_seg('foo'); |
| segno | tupcount |
| -------+---------- |
| 0 | 40 |
| 1 | 0 |
| (2 rows) |
