In the document "Transaction Processing in PostgreSQL" ( http://www.postgresql.org/files/developer/transactions.pdf ) I read : "Postgres transactions are only guaranteed atomic if a disk page write is an atomic action. On most modern hard drives that's true if a page is a physical sector, but most people run with disk pages configured as 8K or so, which makes it a little more dubious whether a page write is all-or-nothing." I have a battery-backed disk controller. In this case: - can such partial writes happen ? - I suppose that a file system never splits a 8K page write request into smaller chunks, and a 8K page will always be fully written ? - with a battery-backed disk controller, a database never gets corrupted ? - Is there a tool that checks if a database is not corrupted ? Best regards Nicolas Riesch
