[HACKERS] Minor inaccuracy in jsonb_path_ops documentation

2014-07-24 Thread Peter Geoghegan
The jsonb documentation says of the jsonb_path_ops GIN opclass: A disadvantage of the jsonb_path_ops approach is that it produces no index entries for JSON structures not containing any values, such as {a: {}}. If a search for documents containing such a structure is requested, it will require a

Re: [HACKERS] Minor inaccuracy in jsonb_path_ops documentation

2014-07-24 Thread Tom Lane
Peter Geoghegan p...@heroku.com writes: The jsonb documentation says of the jsonb_path_ops GIN opclass: A disadvantage of the jsonb_path_ops approach is that it produces no index entries for JSON structures not containing any values, such as {a: {}}. If a search for documents containing such

Re: [HACKERS] Minor inaccuracy in jsonb_path_ops documentation

2014-07-24 Thread Peter Geoghegan
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