3 ms·
> If you're only accessing a small set of known fields you can work around the issue by using plv8 to create function indexes on the fields that you'll be using
by gdulli 13y ago
> If you're only accessing a small set of known fields you can work around the issue by using plv8 to create function indexes on the fields that you'll be using.
You don't need plv8 to create an index on a JSON field, it's supported natively.
- sehrope 13y agoYes my mistake on that. I'm mixing up 9.2 (where you had to do use plv8) and 9.3 (which has the native operator). The rest of the comment still stands though, a parsed representation makes the operator faster and more efficient.