aboutsummaryrefslogtreecommitdiff
path: root/contrib/btree_gist/sql/numeric.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/numeric.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/numeric.sql')
-rw-r--r--contrib/btree_gist/sql/numeric.sql4
1 files changed, 0 insertions, 4 deletions
diff --git a/contrib/btree_gist/sql/numeric.sql b/contrib/btree_gist/sql/numeric.sql
index 55ecbcdadc5..dbb2f2f1838 100644
--- a/contrib/btree_gist/sql/numeric.sql
+++ b/contrib/btree_gist/sql/numeric.sql
@@ -40,11 +40,7 @@ SELECT count(*) FROM numerictmp WHERE a >= 0 ;
SELECT count(*) FROM numerictmp WHERE a > 0 ;
-SET client_min_messages = DEBUG1;
CREATE INDEX numericidx ON numerictmp USING gist ( a );
-CREATE INDEX numericidx_b ON numerictmp USING gist ( a ) WITH (buffering=on);
-DROP INDEX numericidx_b;
-RESET client_min_messages;
SET enable_seqscan=off;