Alvaro Herrera wrote:
XFS, for example, zeroes out during recovery any block
that was written to but not fsync'ed before a crash. This means that if
we change a hint bit after a checkpoing and mark the page dirty, the
system can write the page. Suppose we crash at this point. On
recovery, XFS will zero out the block, but there will be nothing with
which to recovery it, because there's no backup block ...
Really? That would mean that you're prone to lose data if you run
PostgreSQL on XFS, even without the CRC patch.
I doubt that's true, though. Google found this:
http://marc.info/?l=linux-xfs&m=122549156102504&w=2
See the bottom of that mail.
Although, Florian Weimer suggested earlier in this thread that IBM DTLA
disks have exactly that problem; a sector could be zero-filled if the
write is interrupted.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
