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

From: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
To: Chris Browne <cbbrowne(at)acm(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Are there plans to add data compression feature to postgresql?
Date: 2008-10-31 22:33:39
Message-ID: 490B87C3.60802@cheapcomplexdevices.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Eric Schwarzenbach 2008-10-31 22:57:25 [Fwd: Re: GEQO randomness?]
Previous Message Dennis Brakhane 2008-10-31 22:16:35 Re: Wildly erratic query performance