4
CREATE TABLE vactst (i INT);
5
INSERT INTO vactst VALUES (1);
6
INSERT INTO vactst SELECT * FROM vactst;
7
INSERT INTO vactst SELECT * FROM vactst;
8
INSERT INTO vactst SELECT * FROM vactst;
9
INSERT INTO vactst SELECT * FROM vactst;
10
INSERT INTO vactst SELECT * FROM vactst;
11
INSERT INTO vactst SELECT * FROM vactst;
12
INSERT INTO vactst SELECT * FROM vactst;
13
INSERT INTO vactst SELECT * FROM vactst;
14
INSERT INTO vactst SELECT * FROM vactst;
15
INSERT INTO vactst SELECT * FROM vactst;
16
INSERT INTO vactst SELECT * FROM vactst;
17
INSERT INTO vactst VALUES (0);
18
SELECT count(*) FROM vactst;
24
DELETE FROM vactst WHERE i != 0;
32
UPDATE vactst SET i = i + 1;
33
INSERT INTO vactst SELECT * FROM vactst;
34
INSERT INTO vactst SELECT * FROM vactst;
35
INSERT INTO vactst SELECT * FROM vactst;
36
INSERT INTO vactst SELECT * FROM vactst;
37
INSERT INTO vactst SELECT * FROM vactst;
38
INSERT INTO vactst SELECT * FROM vactst;
39
INSERT INTO vactst SELECT * FROM vactst;
40
INSERT INTO vactst SELECT * FROM vactst;
41
INSERT INTO vactst SELECT * FROM vactst;
42
INSERT INTO vactst SELECT * FROM vactst;
43
INSERT INTO vactst SELECT * FROM vactst;
44
INSERT INTO vactst VALUES (0);
45
SELECT count(*) FROM vactst;
51
DELETE FROM vactst WHERE i != 0;
59
VACUUM (FULL, FREEZE) vactst;
60
VACUUM (ANALYZE, FULL) vactst;
61
CREATE TABLE vaccluster (i INT PRIMARY KEY);
62
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "vaccluster_pkey" for table "vaccluster"
63
ALTER TABLE vaccluster CLUSTER ON vaccluster_pkey;
64
INSERT INTO vaccluster SELECT * FROM vactst;
68
VACUUM FULL pg_database;
69
VACUUM FULL vaccluster;
71
DROP TABLE vaccluster;