aboutsummaryrefslogtreecommitdiff
path: root/contrib/btree_gist/sql/char.sql
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/btree_gist/sql/char.sql')
-rw-r--r--contrib/btree_gist/sql/char.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/contrib/btree_gist/sql/char.sql b/contrib/btree_gist/sql/char.sql
index f6eb52e6724..234eabee3b8 100644
--- a/contrib/btree_gist/sql/char.sql
+++ b/contrib/btree_gist/sql/char.sql
@@ -16,7 +16,11 @@ SELECT count(*) FROM chartmp WHERE a >= '31b0'::char(32);
SELECT count(*) FROM chartmp WHERE a > '31b0'::char(32);
+SET client_min_messages = DEBUG1;
CREATE INDEX charidx ON chartmp USING GIST ( a );
+CREATE INDEX charidx_b ON chartmp USING GIST ( a ) WITH (buffering=on);
+DROP INDEX charidx_b;
+RESET client_min_messages;
SET enable_seqscan=off;