aboutsummaryrefslogtreecommitdiff
path: root/contrib/pageinspect/sql/page.sql
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/pageinspect/sql/page.sql')
-rw-r--r--contrib/pageinspect/sql/page.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/contrib/pageinspect/sql/page.sql b/contrib/pageinspect/sql/page.sql
index b5c41cc8ac5..5bff568d3b5 100644
--- a/contrib/pageinspect/sql/page.sql
+++ b/contrib/pageinspect/sql/page.sql
@@ -1,6 +1,7 @@
CREATE EXTENSION pageinspect;
-CREATE TABLE test1 (a int, b int);
+-- Use a temp table so that effects of VACUUM are predictable
+CREATE TEMP TABLE test1 (a int, b int);
INSERT INTO test1 VALUES (16777217, 131584);
VACUUM (DISABLE_PAGE_SKIPPING) test1; -- set up FSM