Re: jsonb and nested hstore

From: Peter Geoghegan <pg(at)heroku(dot)com>
To: Tomas Vondra <tv(at)fuzzy(dot)cz>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: jsonb and nested hstore
Date: 2014-03-11 23:51:50
Message-ID: CAM3SWZT_PYvqD8O5mN9sfxxEj4d7Qo8py2cEVvjidX0dAYWigA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Mar 11, 2014 at 4:41 PM, Peter Geoghegan <pg(at)heroku(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2014-03-11 23:57:05 Re: db_user_namespace a "temporary measure"
Previous Message Simon Riggs 2014-03-11 23:42:20 Re: [PATCH] Store Extension Options