3 ms·
Just wondering if you looked into using GiN or GiST indexes on the JSON in the table?
by kbaker 9y ago
Just wondering if you looked into using GiN or GiST indexes on the JSON in the table?
- malisper 9y agoYes, we have. The problem a lot of our keys and values are numeric. GIN/GiST only support equality for JSON fields. Additionally the GIN/GiST index winds up being significantly larger and is a bit slower than partial indexes.