/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
contrib/btree_gist/sql/inet.sql
49 строк
1 KB
Tom Lane
Create btree_gist v1.9, in which inet/cidr opclasses aren't default.
08 янв 2026, 21:56
08 янв 2026, 21:56
b3b0b45
Код
Авторство
О чём код?
-- inet check CREATE TABLE inettmp (a inet); \copy inettmp from 'data/inet.data' SET enable_seqscan=on; SELECT count(*) FROM inettmp WHERE a < '89.225.196.191'; SELECT count(*) FROM inettmp WHERE a <= '89.225.196.191'; SELECT count(*) FROM inettmp WHERE a = '89.225.196.191'; SELECT count(*) FROM inettmp WHERE a >= '89.225.196.191'; SELECT count(*) FROM inettmp WHERE a > '89.225.196.191'; CREATE INDEX inetidx ON inettmp USING gist ( a gist_inet_ops ); SET enable_seqscan=off; SELECT count(*) FROM inettmp WHERE a < '89.225.196.191'::inet; SELECT count(*) FROM inettmp WHERE a <= '89.225.196.191'::inet; SELECT count(*) FROM inettmp WHERE a = '89.225.196.191'::inet; SELECT count(*) FROM inettmp WHERE a >= '89.225.196.191'::inet; SELECT count(*) FROM inettmp WHERE a > '89.225.196.191'::inet; VACUUM ANALYZE inettmp; -- gist_inet_ops lacks a fetch function, so this should not be index-only scan EXPLAIN (COSTS OFF) SELECT count(*) FROM inettmp WHERE a = '89.225.196.191'::inet; SELECT count(*) FROM inettmp WHERE a = '89.225.196.191'::inet; DROP INDEX inetidx; CREATE INDEX ON inettmp USING gist (a gist_inet_ops, a inet_ops); -- this can be an index-only scan, as long as the planner uses the right column EXPLAIN (COSTS OFF) SELECT count(*) FROM inettmp WHERE a = '89.225.196.191'::inet; SELECT count(*) FROM inettmp WHERE a = '89.225.196.191'::inet;