Re: jsonb and nested hstore - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: jsonb and nested hstore
Date
Msg-id CAM3SWZT_PYvqD8O5mN9sfxxEj4d7Qo8py2cEVvjidX0dAYWigA@mail.gmail.com
Whole thread Raw
In response to Re: jsonb and nested hstore  (Peter Geoghegan <pg@heroku.com>)
Responses Re: jsonb and nested hstore  ("Tomas Vondra" <tv@fuzzy.cz>)
List pgsql-hackers
On Tue, Mar 11, 2014 at 4:41 PM, Peter Geoghegan <pg@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.


-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: [PATCH] Store Extension Options
Next
From: Andrew Dunstan
Date:
Subject: Re: db_user_namespace a "temporary measure"