On 05/10/2014 04:42 PM, Heikki Linnakangas wrote:
The main difference between the two opclasses from a user's standpoint
is not whether they hash or not. The big difference is that one
indexes complete paths from the root, and the other indexes just the
"leaf" level. For example, if you have an object like '{"foo": {"bar":
123 } }', one will index "foo", "foo->bar", and "foo->bar->123" while
the other will index "foo", "bar" and "123".
Whether the opclasses use hashing to shorten the key is an orthogonal
property, and IMHO not as important. To reflect that, I suggest that
we name the opclasses:
json_path_ops
json_value_ops
or something along those lines.
That looks like the first suggestion I've actually liked and that users
will be able to understand.
cheers
andrew
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
