/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
contrib/btree_gist/sql/interval.sql
43 строки
1 KB
Heikki Linnakangas
Revert "Add sortsupport for gist_btree opclasses, for faster index builds."
07 апр 2021, 14:33
07 апр 2021, 14:33
d92b1cd
Код
Авторство
О чём код?
-- interval check CREATE TABLE intervaltmp (a interval); \copy intervaltmp from 'data/interval.data' SET enable_seqscan=on; SELECT count(*) FROM intervaltmp WHERE a < '199 days 21:21:23'; SELECT count(*) FROM intervaltmp WHERE a <= '199 days 21:21:23'; SELECT count(*) FROM intervaltmp WHERE a = '199 days 21:21:23'; SELECT count(*) FROM intervaltmp WHERE a >= '199 days 21:21:23'; SELECT count(*) FROM intervaltmp WHERE a > '199 days 21:21:23'; SELECT a, a <-> '199 days 21:21:23' FROM intervaltmp ORDER BY a <-> '199 days 21:21:23' LIMIT 3; CREATE INDEX intervalidx ON intervaltmp USING gist ( a ); SET enable_seqscan=off; SELECT count(*) FROM intervaltmp WHERE a < '199 days 21:21:23'::interval; SELECT count(*) FROM intervaltmp WHERE a <= '199 days 21:21:23'::interval; SELECT count(*) FROM intervaltmp WHERE a = '199 days 21:21:23'::interval; SELECT count(*) FROM intervaltmp WHERE a >= '199 days 21:21:23'::interval; SELECT count(*) FROM intervaltmp WHERE a > '199 days 21:21:23'::interval; EXPLAIN (COSTS OFF) SELECT a, a <-> '199 days 21:21:23' FROM intervaltmp ORDER BY a <-> '199 days 21:21:23' LIMIT 3; SELECT a, a <-> '199 days 21:21:23' FROM intervaltmp ORDER BY a <-> '199 days 21:21:23' LIMIT 3; SET enable_indexonlyscan=off; EXPLAIN (COSTS OFF) SELECT a, a <-> '199 days 21:21:23' FROM intervaltmp ORDER BY a <-> '199 days 21:21:23' LIMIT 3; SELECT a, a <-> '199 days 21:21:23' FROM intervaltmp ORDER BY a <-> '199 days 21:21:23' LIMIT 3;