summaryrefslogtreecommitdiff
path: root/contrib/btree_gist/sql/cidr.sql
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/btree_gist/sql/cidr.sql')
-rw-r--r--contrib/btree_gist/sql/cidr.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/contrib/btree_gist/sql/cidr.sql b/contrib/btree_gist/sql/cidr.sql
index 9bd77185b96..be2d22b079a 100644
--- a/contrib/btree_gist/sql/cidr.sql
+++ b/contrib/btree_gist/sql/cidr.sql
@@ -15,7 +15,11 @@ SELECT count(*) FROM cidrtmp WHERE a >= '121.111.63.82';
SELECT count(*) FROM cidrtmp WHERE a > '121.111.63.82';
+SET client_min_messages = DEBUG1;
CREATE INDEX cidridx ON cidrtmp USING gist ( a );
+CREATE INDEX cidridx_b ON cidrtmp USING gist ( a ) WITH (buffering=on);
+DROP INDEX cidridx_b;
+RESET client_min_messages;
SET enable_seqscan=off;