CREATE TABLE t AS
SELECT * FROM generate_series(1,1000000) x(i);
SELECT pg_size_pretty(pg_database_size(current_database()));
CREATE INDEX t_idx ON t(i);
SELECT pg_size_pretty(pg_database_size(current_database()));
DROP INDEX t_idx;
SELECT pg_size_pretty(pg_database_size(current_database()));