On Tue, Nov 9, 2010 at 4:26 PM, Jim Nasby <j...@nasby.net> wrote: >> On Tue, Nov 9, 2010 at 3:25 PM, Greg Stark <gsst...@mit.edu> wrote: >>> Oh, I'm mistaken. The problem was that buffering the writes was >>> insufficient to deal with torn pages. Even if you buffer the writes if >>> the machine crashes while only having written half the buffer out then >>> the checksum won't match. If the only changes on the page were hint >>> bit updates then there will be no full page write in the WAL log to >>> repair the block. > > If there's a torn page then we've crashed, which means we go through crash > recovery, which puts a valid page (with valid CRC) back in place from the > WAL. What am I missing?
"If the only changes on the page were hint bit updates then there will be no full page write in the WAL to repair the block" -- greg -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
