On Tue, Feb 25, 2014 at 10:07 PM, Craig Ringer <cr...@2ndquadrant.com> 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.
Yeah. Good idea. Also gonna make a table of what happens when you cast from A to B (via text, json, jsonb, hstore). merlin -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers