4 ms·
After reading through your blog post, I think the feature you should be looking to is expression indexes. Build up the expression that you use repeatedly and an
by darksaints 6y ago
After reading through your blog post, I think the feature you should be looking to is expression indexes. Build up the expression that you use repeatedly and and is so costly, and directly index that.
- murkt 6y agoI have thought about expression indexes, and for expressions I need (@> on jsonb) they can't be used.
- asah 6y agoCan you wrap that operator call in a function, and index the output of that function? (sorry if dumb q - but I've used this technique myself, and indeed, my favorite hack in recent years are JavaScript UDFs in plv8... super ugly but very very flexible...)
- murkt 6y agoI'm not sure I can, and I definitely do not want to do that. I'm happy with a separate table and `btree` index on it.