aboutsummaryrefslogtreecommitdiff
path: root/contrib/btree_gist/sql/bytea.sql
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/btree_gist/sql/bytea.sql')
-rw-r--r--contrib/btree_gist/sql/bytea.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/contrib/btree_gist/sql/bytea.sql b/contrib/btree_gist/sql/bytea.sql
index 6885f5e56d5..fdfa0c345bd 100644
--- a/contrib/btree_gist/sql/bytea.sql
+++ b/contrib/btree_gist/sql/bytea.sql
@@ -17,7 +17,11 @@ SELECT count(*) FROM byteatmp WHERE a >= '31b0';
SELECT count(*) FROM byteatmp WHERE a > '31b0';
+SET client_min_messages = DEBUG1;
CREATE INDEX byteaidx ON byteatmp USING GIST ( a );
+CREATE INDEX byteaidx_b ON byteatmp USING GIST ( a ) WITH (buffering=on);
+DROP INDEX byteaidx_b;
+RESET client_min_messages;
SET enable_seqscan=off;