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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
