Re: jsonb and nested hstore

From: Peter Geoghegan <pg(at)heroku(dot)com>
To: obartunov(at)gmail(dot)com
Cc: Tomas Vondra <tv(at)fuzzy(dot)cz>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: jsonb and nested hstore
Date: 2014-03-12 20:10:37
Message-ID: CAM3SWZT-2bFGgsG48zqX1-bbYirOCfkkPahaNY5nfTX_ujqtRw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Mar 12, 2014 at 11:57 AM, Oleg Bartunov <obartunov(at)gmail(dot)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?

--
Peter Geoghegan

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2014-03-12 20:33:14 Re: Replication slots and footguns
Previous Message Peter Geoghegan 2014-03-12 19:40:40 Re: jsonb and nested hstore