Re: Are there plans to add data compression feature to postgresql?

Поиск
Список
Период
Сортировка
От Ron Mayer
Тема Re: Are there plans to add data compression feature to postgresql?
Дата
Msg-id 490B87C3.60802@cheapcomplexdevices.com
обсуждение исходный текст
Ответ на Re: Are there plans to add data compression feature to postgresql?  (Chris Browne <cbbrowne@acm.org>)
Список pgsql-general
Chris Browne wrote:
> There's a way that compressed filesystems might *help* with a risk
> factor, here...
> By reducing the number of disk drives required to hold the data, you
> may be reducing the risk of enough of them failing to invalidate the
> RAID array.

And one more way.

If neither your database nor filesystem do checksums on
blocks (seems the compressing filesystems mostly do checksums, tho),
a one bit error may go undetected corrupting your data without you
knowing it.

With a filesystem compression, that one bit error is likely to grow
into something big enough to be detected immediately.


В списке pgsql-general по дате отправления:

Предыдущее
От: Dennis Brakhane
Дата:
Сообщение: Re: Wildly erratic query performance
Следующее
От: Eric Schwarzenbach
Дата:
Сообщение: [Fwd: Re: GEQO randomness?]