/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
contrib/btree_gist/sql/int8.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
Код
Авторство
О чём код?
-- int8 check CREATE TABLE int8tmp (a int8); \copy int8tmp from 'data/int8.data' SET enable_seqscan=on; SELECT count(*) FROM int8tmp WHERE a < 464571291354841; SELECT count(*) FROM int8tmp WHERE a <= 464571291354841; SELECT count(*) FROM int8tmp WHERE a = 464571291354841; SELECT count(*) FROM int8tmp WHERE a >= 464571291354841; SELECT count(*) FROM int8tmp WHERE a > 464571291354841; SELECT a, a <-> '464571291354841' FROM int8tmp ORDER BY a <-> '464571291354841' LIMIT 3; CREATE INDEX int8idx ON int8tmp USING gist ( a ); SET enable_seqscan=off; SELECT count(*) FROM int8tmp WHERE a < 464571291354841::int8; SELECT count(*) FROM int8tmp WHERE a <= 464571291354841::int8; SELECT count(*) FROM int8tmp WHERE a = 464571291354841::int8; SELECT count(*) FROM int8tmp WHERE a >= 464571291354841::int8; SELECT count(*) FROM int8tmp WHERE a > 464571291354841::int8; EXPLAIN (COSTS OFF) SELECT a, a <-> '464571291354841' FROM int8tmp ORDER BY a <-> '464571291354841' LIMIT 3; SELECT a, a <-> '464571291354841' FROM int8tmp ORDER BY a <-> '464571291354841' LIMIT 3;