aboutsummaryrefslogtreecommitdiff
path: root/contrib/btree_gist/sql/timetz.sql
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/btree_gist/sql/timetz.sql')
-rw-r--r--contrib/btree_gist/sql/timetz.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/contrib/btree_gist/sql/timetz.sql b/contrib/btree_gist/sql/timetz.sql
index 2fb725db747..bc79d134b8f 100644
--- a/contrib/btree_gist/sql/timetz.sql
+++ b/contrib/btree_gist/sql/timetz.sql
@@ -42,7 +42,11 @@ INSERT INTO timetzcmp (r_id,a) SELECT 25,count(*) FROM timetztmp WHERE a > '07:
+SET client_min_messages = DEBUG1;
CREATE INDEX timetzidx ON timetztmp USING gist ( a );
+CREATE INDEX timetzidx_b ON timetztmp USING gist ( a ) WITH (buffering=on);
+DROP INDEX timetzidx_b;
+RESET client_min_messages;
SET enable_seqscan=off;