Re: jsonb status - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: jsonb status
Date
Msg-id CAM3SWZRS_2mJZzCYhsrTahrw8EFK10sj-KVO+hOoS5GKY-SqVQ@mail.gmail.com
Whole thread Raw
In response to Re: jsonb status  (Bruce Momjian <bruce@momjian.us>)
Responses Re: jsonb status  (Oleg Bartunov <obartunov@gmail.com>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: jsonb status
Next
From: Bruce Momjian
Date:
Subject: Re: Useless "Replica Identity: NOTHING" noise from psql \d