Re: jsonb format is pessimal for toast compression - Mailing list pgsql-hackers

From Andres Freund
Subject Re: jsonb format is pessimal for toast compression
Date
Msg-id 20140925190007.GD16581@awork2.anarazel.de
Whole thread Raw
In response to Re: jsonb format is pessimal for toast compression  (Bruce Momjian <bruce@momjian.us>)
Responses Re: jsonb format is pessimal for toast compression  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
On 2014-09-25 14:46:18 -0400, Bruce Momjian wrote:
> On Thu, Sep 25, 2014 at 02:39:37PM -0400, Tom Lane wrote:
> > BTW, it seems like there is consensus that we ought to reorder the items
> > in a jsonb object to have keys first and then values, independently of the
> > other issues under discussion.  This means we *will* be breaking on-disk
> > compatibility with 9.4beta2, which means pg_upgrade will need to be taught
> > to refuse an upgrade if the database contains any jsonb columns.  Bruce,
> > do you have time to crank out a patch for that?
> 
> Yes, I can do that easily.  Tell me when you want it --- I just need a
> catalog version number to trigger on.

Do you plan to make it conditional on jsonb being used in the database?
That'd not be bad to reduce the pain for testers that haven't used jsonb.

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}
Next
From: Robert Haas
Date:
Subject: Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}