17 ms·
So you added a generated boolean column that uses the value from a another boolean column? Sounds like a strange concept. Did you try a filtered index using WH
by hans_castorp 3y ago
So you added a generated boolean column that uses the value from a another boolean column? Sounds like a strange concept.
Did you try a filtered index using WHERE ... IS NOT NULL instead?
Or maybe an index on an expression coalesce(the_column, false) and then use that expression the where clause?