Re: jsonb format is pessimal for toast compression - Mailing list pgsql-hackers

From Tom Lane
Subject Re: jsonb format is pessimal for toast compression
Date
Msg-id 16744.1409080633@sss.pgh.pa.us
Whole thread Raw
In response to Re: jsonb format is pessimal for toast compression  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: jsonb format is pessimal for toast compression
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Laurence Rowe
Date:
Subject: Re: jsonb format is pessimal for toast compression
Next
From: Claudio Freire
Date:
Subject: Re: jsonb format is pessimal for toast compression