On Thu, Jul 24, 2014 at 3:02 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > The fact that the planner can avoid that in the presence of a > simple constant comparison value doesn't make it a good idea to > use jsonb_path_ops indexes if you do this type of query a lot, > because in some usages the planner won't see a constant comparison > value, and if so it'll likely choose an indexscan by default.
Well, with idiomatic usage a constant value generally will be used. But I do see your point. -- Peter Geoghegan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers