/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
contrib/btree_gist/sql/oid.sql
30 строк
686 B
Heikki Linnakangas
Revert "Add sortsupport for gist_btree opclasses, for faster index builds."
07 апр 2021, 14:33
07 апр 2021, 14:33
d92b1cd
Код
Авторство
О чём код?
-- oid check SET enable_seqscan=on; CREATE TEMPORARY TABLE oidtmp (oid oid); INSERT INTO oidtmp SELECT g.i::oid FROM generate_series(1, 1000) g(i); SELECT count(*) FROM oidtmp WHERE oid < 17; SELECT count(*) FROM oidtmp WHERE oid <= 17; SELECT count(*) FROM oidtmp WHERE oid = 17; SELECT count(*) FROM oidtmp WHERE oid >= 17; SELECT count(*) FROM oidtmp WHERE oid > 17; CREATE INDEX oididx ON oidtmp USING gist ( oid ); SET enable_seqscan=off; SELECT count(*) FROM oidtmp WHERE oid < 17; SELECT count(*) FROM oidtmp WHERE oid <= 17; SELECT count(*) FROM oidtmp WHERE oid = 17; SELECT count(*) FROM oidtmp WHERE oid >= 17; SELECT count(*) FROM oidtmp WHERE oid > 17;