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;