Re: jsonb format is pessimal for toast compression

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: jsonb format is pessimal for toast compression
Дата
Msg-id 16744.1409080633@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: jsonb format is pessimal for toast compression  (Andres Freund <andres@2ndquadrant.com>)
Ответы Re: jsonb format is pessimal for toast compression
Список 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 по дате отправления:

Предыдущее
От: Laurence Rowe
Дата:
Сообщение: Re: jsonb format is pessimal for toast compression
Следующее
От: Claudio Freire
Дата:
Сообщение: Re: jsonb format is pessimal for toast compression