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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers