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