Re: Are there plans to add data compression feature to postgresql? - Mailing list pgsql-general

From Ron Mayer
Subject Re: Are there plans to add data compression feature to postgresql?
Date
Msg-id 490B87C3.60802@cheapcomplexdevices.com
Whole thread Raw
In response to Re: Are there plans to add data compression feature to postgresql?  (Chris Browne <cbbrowne@acm.org>)
List 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 by date:

Previous
From: Dennis Brakhane
Date:
Subject: Re: Wildly erratic query performance
Next
From: Eric Schwarzenbach
Date:
Subject: [Fwd: Re: GEQO randomness?]