On Sat, Mar 22, 2014 at 5:22 PM, Bruce Momjian <bruce@momjian.us> wrote:
> What did you decide about hashing values in indexes vs. putting them in
> literally?
There are two GIN opclasses supplied. There is a default, which
supports more operators (various "existence" operators - see the
documentation). There is an alternative called jsonb_hash_ops that
only supports containment, and performs considerably better than the
default. Containment *is* the compelling operator to support, though -
you can do rather a lot with it. This must be what you're referring
to, since I recall you blogged about the response it got at pgConf.EU.
Both are available.
--
Peter Geoghegan