aboutsummaryrefslogtreecommitdiff
path: root/contrib/btree_gist/sql/inet.sql
diff options
context:
space:
mode:
authorHeikki Linnakangas <heikki.linnakangas@iki.fi>2021-04-07 14:33:21 +0300
committerHeikki Linnakangas <heikki.linnakangas@iki.fi>2021-04-07 14:33:21 +0300
commitd92b1cdbab408d8f1299257125c9ae375f3ca644 (patch)
treee75e26cae720ad2f4a0e1d8ef071ae197924c45a /contrib/btree_gist/sql/inet.sql
parent9f984ba6d23dc6eecebf479ab1d3f2e550a4e9be (diff)
downloadpostgresql-d92b1cdbab408d8f1299257125c9ae375f3ca644.tar.gz
postgresql-d92b1cdbab408d8f1299257125c9ae375f3ca644.zip
Revert "Add sortsupport for gist_btree opclasses, for faster index builds."
This reverts commit 9f984ba6d23dc6eecebf479ab1d3f2e550a4e9be. It was making the buildfarm unhappy, apparently setting client_min_messages in a regression test produces different output if log_statement='all'. Another issue is that I now suspect the bit sortsupport function was in fact not correct to call byteacmp(). Revert to investigate both of those issues.
Diffstat (limited to 'contrib/btree_gist/sql/inet.sql')
-rw-r--r--contrib/btree_gist/sql/inet.sql4
1 files changed, 0 insertions, 4 deletions
diff --git a/contrib/btree_gist/sql/inet.sql b/contrib/btree_gist/sql/inet.sql
index 0339c853d38..4b8d354b00e 100644
--- a/contrib/btree_gist/sql/inet.sql
+++ b/contrib/btree_gist/sql/inet.sql
@@ -16,11 +16,7 @@ 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;