"Scott Marlowe" <scott.marlowe@gmail.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