Re: jsonb format is pessimal for toast compression

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: jsonb format is pessimal for toast compression
Дата
Msg-id 20140925190007.GD16581@awork2.anarazel.de
обсуждение исходный текст
Ответ на Re: jsonb format is pessimal for toast compression  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: jsonb format is pessimal for toast compression  (Bruce Momjian <bruce@momjian.us>)
Список 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 по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}
Следующее
От: Robert Haas
Дата:
Сообщение: Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}