DROP TABLE SELECT 500000 CREATE INDEX SET SET SET SET pg_size_pretty ---------------- 48 MB (1 row) DELETE 500000 pg_size_pretty ---------------- 48 MB (1 row) box ----- (0 rows) INSERT 0 500000 pg_size_pretty ---------------- 48 MB (1 row) INSERT 0 500000 pg_size_pretty ---------------- 48 MB (1 row) INSERT 0 500000 pg_size_pretty ---------------- 95 MB (1 row)