"Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> writes:
> Sure, bash Microsoft it's easy. But it doesn't address the point, is
> a database safe on top of a compressed file system and if not, why?
It is certainly *less* safe than it is on top of an uncompressed
filesystem. Any given hardware failure will affect more stored bits
(if the compression is effective) in a less predictable way.
If you assume that hardware failure rates are below your level of
concern, this doesn't matter. But DBAs are paid to be paranoid.
regards, tom lane
In response to
pgsql-general by date
|Next:||From: Kyle Cordes||Date: 2008-10-31 04:32:59|
|Subject: Re: Decreasing WAL size effects|
|Previous:||From: Scott Marlowe||Date: 2008-10-31 03:15:41|
|Subject: Re: Are there plans to add data compression feature to postgresql?|