Simon Riggs wrote: > On Tue, 2009-12-01 at 07:05 -0500, Bruce Momjian wrote: > > > I assume torn pages are 99% of the reported problem, which are > > expected and are fixed, and bad hardware 1%, quite the opposite of your > > numbers above. > > On what basis do you make that assumption?
Because we added full page write protection to fix the reported problem of torn pages, which we had on occasion; now we don't. Bad hardware reports are less frequent. And we know we can reproduce torn pages by shutting of power to a server without battery-backed cache. We don't know how to produce I/O failures on demand. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers