Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group