On Thu, Mar 13, 2014 at 12:10 AM, Peter Geoghegan <p...@heroku.com> wrote: > On Wed, Mar 12, 2014 at 11:57 AM, Oleg Bartunov <obartu...@gmail.com> wrote: >> Also, GiST index is faster for create/update operations. I really hope we >> will >> improve jsonb indexing in the next one-two releases. For now I'd suggest >> people >> index expressional indexes to index just interesting keys or use GiST. > > When do you ever want to index non-interesting keys?
Regular user may just index all keys. I mean, that json can contains keys, which are not searched, so it's not needed to index them and save index size. We probably could provide option in CREATE INDEX to specify what to index and what not index, but it require planner to know that information. > > -- > Peter Geoghegan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
