Re: jsonb format is pessimal for toast compression

Andres Freund <andres@2ndquadrant.com> writes:
> On 2014-08-26 15:01:27 -0400, Tom Lane wrote:
>> Yeah, exactly.  Given current hardware trends, data compression is
>> becoming more of a win not less as time goes on: CPU cycles are cheap
>> even compared to main memory access, let alone mass storage.  So I'm
>> thinking we want to adopt a compression-friendly data format even if
>> it measures out as a small loss currently.

> On the other hand the majority of databases these day fit into main
> memory due to its increasing sizes and postgres is more often CPU than
> IO bound.

Well, better data compression helps make that true ;-).  And don't forget
cache effects; actual main memory is considered slow these days.
        regards, tom lane