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
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 Schwarzenbach||Date: 2008-10-31 22:57:25|
|Subject: [Fwd: Re: GEQO randomness?]|
|Previous:||From: Dennis Brakhane||Date: 2008-10-31 22:16:35|
|Subject: Re: Wildly erratic query performance|