Just to let people know about our experiments.
Consider this top-level query, which well supported by GIN in 9.4.
postgres=# select count(*) from jb where jb @> '{"tags":[{"term":"NYC"}]}'::jsonb;
count
-------
285
(1 row)
What if I want to find just {"term":"NYC"}, or even "NYC" ? Now, with some improvements, jsonb_hash_ops supports such
(
Read more... )