Re: jsonb format is pessimal for toast compression

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: "David E(dot) Wheeler" <david(at)justatheory(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Jan Wieck <jan(at)wi3ck(dot)info>
Subject: Re: jsonb format is pessimal for toast compression
Date: 2014-09-12 17:00:34
Message-ID: CA+TgmobqnAXwBXJXhPG4X-0K5yPKeq6Cm_YG822gN6L9u7j2jQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Sep 12, 2014 at 1:00 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> On Thu, Sep 11, 2014 at 9:01 PM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
>> So, I finally got time to test Tom's latest patch on this.
>>
>> TLDR: we want to go with Tom's latest patch and release beta3.
>>
>> Figures:
>>
>> So I tested HEAD against the latest lengths patch. Per Arthur Silva, I
>> checked uncompressed times for JSONB against compressed times. This
>> changed the picture considerably.
>
> Did you

Blah.

Did you test Heikki's patch from here?

http://www.postgresql.org/message-id/53EC8194.4020804@vmware.com

Tom didn't like it, but I thought it was rather clever.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2014-09-12 17:10:31 Re: Stating the significance of Lehman & Yao in the nbtree README
Previous Message Robert Haas 2014-09-12 17:00:05 Re: jsonb format is pessimal for toast compression