Re: jsonb format is pessimal for toast compression

On 08/14/2014 04:47 PM, Josh Berkus wrote:
>  thetype |    colsize_distribution
> ---------+----------------------------
>  json    | {1777,1803,1890,1940,4424}
>  jsonb   | {5902,5926,5978,6002,6208}

Just realized my query was counting the whole row size instead of just
the column size.  Here's just the JSON column:

Before changing to to INT_MAX:
thetype |    colsize_distribution
---------+----------------------------json    | {1741,1767,1854,1904,2292}jsonb   | {3551,5866,5910,5958,6168}

After:
thetype |    colsize_distribution
---------+----------------------------json    | {1741,1767,1854,1904,2292}jsonb   | {3515,3543,3636,3690,4038}

So that did improve things, just not as much as we'd like.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com