3 ms·
> indexes often don't help. An "index on expression" should perform the same regardless of the input column types. All that matters is the output of the expres
by phamilton 2y ago
> indexes often don't help.
An "index on expression" should perform the same regardless of the input column types. All that matters is the output of the expression. Were you just indexing the whole jsonb column or were you indexing a specific expression?
For example, an index on `foo(user_id)` vs `foo(data->'user_id')` should perform the same.