Ensure that queries are properly indexable with GIN indexes
Opened this issue · 0 comments
oskardudycz commented
It may be needed to fallback to regular queries instead of JSON Path for some queries if they're not using GIN indexes.
Read more:
- https://blog.sql-workbench.eu/post/json-path/
- https://stackoverflow.com/questions/63525024/can-postgresql-index-deeper-paths-into-json-columns
- https://stackoverflow.com/questions/68728454/index-json-field-to-be-used-in-jsonpath-comparison-expression
- https://vsevolod.net/postgresql-jsonb-index/
- https://www.postgresql.org/message-id/15DD78A5-B5C4-4332-ACFE-55723259C07F%40justatheory.com
If that was improved with latest versions, we can ignore it, if not then need to do fallback.