Re: default opclass for jsonb (was Re: Call for GIST/GIN/SP-GIST opclass documentation) - Mailing list pgsql-hackers

From Alexander Korotkov
Subject Re: default opclass for jsonb (was Re: Call for GIST/GIN/SP-GIST opclass documentation)
Date
Msg-id CAPpHfdtFpdYQXFJP+EnZMjfdz-1ARaaAJgHZX+-pdHyyjuMS-w@mail.gmail.com
Whole thread Raw
In response to Re: default opclass for jsonb (was Re: Call for GIST/GIN/SP-GIST opclass documentation)  (Heikki Linnakangas <hlinnakangas@vmware.com>)
List pgsql-hackers
On Wed, Apr 9, 2014 at 10:37 AM, Heikki Linnakangas <hlinnakangas@vmware.com> wrote:
The ship has cleatly sailed to add parameterized opclasses to 9.4, but let's keep it in mind when we decide on the defaults.

In the absence of parameterizable opclasses, it would be much more flexible to have opclasses that index, keys, values, key-value pairs and paths separately, instead of the current json_ops and json_hash_ops opclasses which index all of those in the same index. That way, if you only e.g. ever query on the existence of a key, you'd only need to index the keys.

I don't understand how we ended up with the current dichotomy of json_ops and json_hash_ops...

+1 for parameterizable opclasses

------
With best regards,
Alexander Korotkov.

pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: New option in pg_basebackup to exclude pg_log files during base backup
Next
From: Tom Lane
Date:
Subject: Re: Get more from indices.