On Thu, Jul 24, 2014 at 3:02 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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