On 12 Březen 2014, 0:51, Peter Geoghegan wrote: > On Tue, Mar 11, 2014 at 4:41 PM, Peter Geoghegan <p...@heroku.com> wrote: >> I think that in practice the >> general recommendation will be that when indexing at the "top level", >> use jsonb_hash_ops. When indexing nested items, use the more flexible >> default GIN opclass. That seems like a pretty smart trade-off to me. > > By which I mean: index nested items using an expressional GIN index.
I'm still not sure how would that look. Does that mean I'd have to create multiple GIN indexes - one for each possible key or something like that? Can you give an example? regards Tomas -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers