/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
contrib/btree_gist/sql/macaddr.sql
37 строк
1 KB
Heikki Linnakangas
Revert "Add sortsupport for gist_btree opclasses, for faster index builds."
07 апр 2021, 14:33
07 апр 2021, 14:33
d92b1cd
Код
Авторство
О чём код?
-- macaddr check CREATE TABLE macaddrtmp (a macaddr); \copy macaddrtmp from 'data/macaddr.data' SET enable_seqscan=on; SELECT count(*) FROM macaddrtmp WHERE a < '22:00:5c:e5:9b:0d'; SELECT count(*) FROM macaddrtmp WHERE a <= '22:00:5c:e5:9b:0d'; SELECT count(*) FROM macaddrtmp WHERE a = '22:00:5c:e5:9b:0d'; SELECT count(*) FROM macaddrtmp WHERE a >= '22:00:5c:e5:9b:0d'; SELECT count(*) FROM macaddrtmp WHERE a > '22:00:5c:e5:9b:0d'; CREATE INDEX macaddridx ON macaddrtmp USING gist ( a ); SET enable_seqscan=off; SELECT count(*) FROM macaddrtmp WHERE a < '22:00:5c:e5:9b:0d'::macaddr; SELECT count(*) FROM macaddrtmp WHERE a <= '22:00:5c:e5:9b:0d'::macaddr; SELECT count(*) FROM macaddrtmp WHERE a = '22:00:5c:e5:9b:0d'::macaddr; SELECT count(*) FROM macaddrtmp WHERE a >= '22:00:5c:e5:9b:0d'::macaddr; SELECT count(*) FROM macaddrtmp WHERE a > '22:00:5c:e5:9b:0d'::macaddr; -- Test index-only scans SET enable_bitmapscan=off; EXPLAIN (COSTS OFF) SELECT * FROM macaddrtmp WHERE a < '02:03:04:05:06:07'::macaddr; SELECT * FROM macaddrtmp WHERE a < '02:03:04:05:06:07'::macaddr;