aboutsummaryrefslogtreecommitdiff
path: root/contrib/btree_gist/sql/inet.sql
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/btree_gist/sql/inet.sql')
-rw-r--r--contrib/btree_gist/sql/inet.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/contrib/btree_gist/sql/inet.sql b/contrib/btree_gist/sql/inet.sql
index 4b8d354b00e..0339c853d38 100644
--- a/contrib/btree_gist/sql/inet.sql
+++ b/contrib/btree_gist/sql/inet.sql
@@ -16,7 +16,11 @@ SELECT count(*) FROM inettmp WHERE a >= '89.225.196.191';
SELECT count(*) FROM inettmp WHERE a > '89.225.196.191';
+SET client_min_messages = DEBUG1;
CREATE INDEX inetidx ON inettmp USING gist ( a );
+CREATE INDEX inetidx_b ON inettmp USING gist ( a ) WITH (buffering=on);
+DROP INDEX inetidx_b;
+RESET client_min_messages;
SET enable_seqscan=off;