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