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. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers