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 <j...@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 -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers