Re: jsonb and nested hstore

On 02/25/2014 08:07 PM, Craig Ringer wrote:
> On 02/26/2014 06:21 AM, Merlin Moncure wrote:
>> On Tue, Feb 25, 2014 at 4:03 PM, Josh Berkus <josh@agliodbs.com> wrote:
>>> On 02/25/2014 12:12 PM, Robert Haas wrote:
>>>> I don't agree that jsonb should be preferred in all but a handful of
>>>> situations.  Nor do I agree that partisanship belongs in our
>>>> documentation.  Therefore, -1 for your proposal to recommend that, and
>>>> +1 for Merlin's proposal to present a comparison which fairly
>>>> illustrates the situations in which each will outperform the other.
>>>
>>> Awaiting doc patch from Merlin, then.  It will need to be clear enough
>>> that an ordinary user can distinguish which type they want.
>>
>> Sure.
> 
> Please also highlight that any change will require a full table rewrite
> with an exclusive lock, so data type choices on larger tables may be
> hard to change later.

Oh, point.  I'll add that text if Merlin doesn't.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com