4 ms·
I’ve even found “Is not null” queries on a Boolean column to be slow so I made a generated column that’s Boolean.
by hrdwdmrbl 3y ago
I’ve even found “Is not null” queries on a Boolean column to be slow so I made a generated column that’s Boolean.
- hans_castorp 3y agoSo 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?