/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
contrib/btree_gin/sql/bool.sql
29 строк
1 KB
Tom Lane
Produce more-optimal plans for bitmap scans on boolean columns.
08 ноя 2022, 18:36
08 ноя 2022, 18:36
042c909
Код
Авторство
О чём код?
set enable_seqscan=off; CREATE TABLE test_bool ( i boolean ); INSERT INTO test_bool VALUES (false),(true),(null); CREATE INDEX idx_bool ON test_bool USING gin (i); SELECT * FROM test_bool WHERE i<true ORDER BY i; SELECT * FROM test_bool WHERE i<=true ORDER BY i; SELECT * FROM test_bool WHERE i=true ORDER BY i; SELECT * FROM test_bool WHERE i>=true ORDER BY i; SELECT * FROM test_bool WHERE i>true ORDER BY i; SELECT * FROM test_bool WHERE i<false ORDER BY i; SELECT * FROM test_bool WHERE i<=false ORDER BY i; SELECT * FROM test_bool WHERE i=false ORDER BY i; SELECT * FROM test_bool WHERE i>=false ORDER BY i; SELECT * FROM test_bool WHERE i>false ORDER BY i; EXPLAIN (COSTS OFF) SELECT * FROM test_bool WHERE i<true ORDER BY i; EXPLAIN (COSTS OFF) SELECT * FROM test_bool WHERE i<=true ORDER BY i; EXPLAIN (COSTS OFF) SELECT * FROM test_bool WHERE i=true ORDER BY i; EXPLAIN (COSTS OFF) SELECT * FROM test_bool WHERE i>=true ORDER BY i; EXPLAIN (COSTS OFF) SELECT * FROM test_bool WHERE i>true ORDER BY i; -- probably sufficient to check just this one: EXPLAIN (COSTS OFF) SELECT * FROM test_bool WHERE i=false ORDER BY i;