/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
contrib/btree_gist/sql/varbit.sql
36 строк
982 B
Heikki Linnakangas
Revert "Add sortsupport for gist_btree opclasses, for faster index builds."
07 апр 2021, 14:33
07 апр 2021, 14:33
d92b1cd
Код
Авторство
О чём код?
-- varbit check CREATE TABLE varbittmp (a varbit); \copy varbittmp from 'data/varbit.data' SET enable_seqscan=on; SELECT count(*) FROM varbittmp WHERE a < '1110100111010'; SELECT count(*) FROM varbittmp WHERE a <= '1110100111010'; SELECT count(*) FROM varbittmp WHERE a = '1110100111010'; SELECT count(*) FROM varbittmp WHERE a >= '1110100111010'; SELECT count(*) FROM varbittmp WHERE a > '1110100111010'; CREATE INDEX varbitidx ON varbittmp USING GIST ( a ); SET enable_seqscan=off; SELECT count(*) FROM varbittmp WHERE a < '1110100111010'::varbit; SELECT count(*) FROM varbittmp WHERE a <= '1110100111010'::varbit; SELECT count(*) FROM varbittmp WHERE a = '1110100111010'::varbit; SELECT count(*) FROM varbittmp WHERE a >= '1110100111010'::varbit; SELECT count(*) FROM varbittmp WHERE a > '1110100111010'::varbit; -- Test index-only scans SET enable_bitmapscan=off; EXPLAIN (COSTS OFF) SELECT a FROM bittmp WHERE a BETWEEN '1000000' and '1000001';