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