diff --git a/contrib/pg_freespacemap/Makefile b/contrib/pg_freespacemap/Makefile index da40b80c7c..23cfb67c35 100644 --- a/contrib/pg_freespacemap/Makefile +++ b/contrib/pg_freespacemap/Makefile @@ -9,6 +9,7 @@ EXTENSION = pg_freespacemap DATA = pg_freespacemap--1.1.sql pg_freespacemap--1.1--1.2.sql \ pg_freespacemap--1.0--1.1.sql PGFILEDESC = "pg_freespacemap - monitoring of free space map" +REGRESS = pg_freespacemap ifdef USE_PGXS PG_CONFIG = pg_config diff --git a/contrib/pg_freespacemap/expected/pg_freespacemap.out b/contrib/pg_freespacemap/expected/pg_freespacemap.out new file mode 100644 index 0000000000..838936bb39 --- /dev/null +++ b/contrib/pg_freespacemap/expected/pg_freespacemap.out @@ -0,0 +1,16 @@ +CREATE EXTENSION pg_freespacemap; +CREATE TABLE t1(c1 int); +INSERT INTO t1 VALUES (generate_series(1, 100)); +VACUUM t1; +SELECT * FROM pg_freespace('t1'); + blkno | avail +-------+------- + 0 | 4544 +(1 row) + +SELECT * FROM pg_freespace('t1', 0); + pg_freespace +-------------- + 4544 +(1 row) + diff --git a/contrib/pg_freespacemap/sql/pg_freespacemap.sql b/contrib/pg_freespacemap/sql/pg_freespacemap.sql new file mode 100644 index 0000000000..f69f767811 --- /dev/null +++ b/contrib/pg_freespacemap/sql/pg_freespacemap.sql @@ -0,0 +1,9 @@ +CREATE EXTENSION pg_freespacemap; + +CREATE TABLE t1(c1 int); + +INSERT INTO t1 VALUES (generate_series(1, 100)); +VACUUM t1; + +SELECT * FROM pg_freespace('t1'); +SELECT * FROM pg_freespace('t1', 0);