Postgres Pro
Downloads
Home   >   mailing lists

Re: JsonB Gin Index is very large; is there a work around? - Mailing list pgsql-general

From Peter Geoghegan
Subject Re: JsonB Gin Index is very large; is there a work around?
Date
Msg-id CAEYLb_VWbTv-jKXyqgGJqiiU5vNYa8YpNaNuWz=kgdn1dVaEOQ@mail.gmail.com
Whole thread Raw
In response to JsonB Gin Index is very large; is there a work around?  (Larry White <ljw1001@gmail.com>)
Responses Re: JsonB Gin Index is very large; is there a work around?  (Larry White <ljw1001@gmail.com>)
List pgsql-general
Tree view 
On Wed, Aug 20, 2014 at 1:53 PM, Larry White <ljw1001@gmail.com> wrote:
> Is there anyway to index a subset of the data in a JSONB column? I'm
> thinking of something like declaring certain paths to be indexed?


Yes. See the expression index example in the jsonb documentation.

--
Regards,
Peter Geoghegan

pgsql-general by date:

Previous
From: Larry White
Date:
Subject: JsonB Gin Index is very large; is there a work around?
Next
From: Larry White
Date:
Subject: Re: JsonB Gin Index is very large; is there a work around?