Re: jsonb and nested hstore - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: jsonb and nested hstore
Date
Msg-id CAM3SWZSQK0LoLg7uVYwhSx54PBcFd7dkeRLfDp5+JSy78EFd2w@mail.gmail.com
Whole thread Raw
In response to Re: jsonb and nested hstore  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: jsonb and nested hstore  (Bruce Momjian <bruce@momjian.us>)
Re: jsonb and nested hstore  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
On Wed, Mar 5, 2014 at 8:30 AM, Robert Haas <robertmhaas@gmail.com> wrote:
>> Just out of curiosity, exactly what features are missing from jsonb
>> today that are available with hstore?  How long would it take to
>> copy-and-paste all that code, if someone were to decide to do the
>> work instead of argue about it?
>
> I believe the main thing is the opclasses.

Yes, that's right. A large volume of code currently proposed for
hstore2 is much less valuable than those operators sufficient to
implement the hstore2 opclasses. If you assume that hstore will become
a legacy extension that we won't add anything to (including everything
proposed in any patch posted to this thread), and jsonb will go in
core (which is of course more or less just hstore2 with a few json
extras), the amount of code redundantly shared between core and an
unchanged hstore turns out to not be that bad. I hope to have a
precise answer to just how bad soon.

-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: API change advice: Passing plan invalidation info from the rewriter into the planner?
Next
From: Tom Lane
Date:
Subject: Re: UNION ALL on partitioned tables won't use indices.