Is it true that the planner currently doesn't utilize index for BYTEA
column in OR or IN clause?
-- b is an indexed BYTEA column
explain select * from t where b='foo'; -- index scan
explain select * from t where b like 'f%'; -- index
explain select * from t where b='foo' or b='bar'; -- seq scan
explain select * from t where b='foo' or b like 'b%'; -- seq
explain select * from t where b like 'f%' or b like 'b%'; -- seq
explain select * from t where b in ('foo','bar'); -- seq
Currently I'm setting enable_seqscan to off for these...
--
dave