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