Re: Page Checksums + Double Writes
Greg Stark <stark@mit.edu>
From: Greg Stark <stark@mit.edu>
To: Merlin Moncure <mmoncure@gmail.com>
Cc: Jeff Davis <pgsql@j-davis.com>, Kevin Grittner <Kevin.Grittner@wicourts.gov>, simon@2ndquadrant.com, tgl@sss.pgh.pa.us, alvherre@commandprompt.com, david@fetter.org, pgsql-hackers@postgresql.org
Date: 2011-12-28T14:45:11Z
Lists: pgsql-hackers
On Tue, Dec 27, 2011 at 10:43 PM, Merlin Moncure <mmoncure@gmail.com> wrote: > I bet if you kept a judicious number of > clog pages in each local process with some smart invalidation you > could cover enough cases that scribbling the bits down would become > unnecessary. I don't understand how any cache can completely remove the need for hint bits. Without hint bits the xids in the tuples will be "in-doubt" forever. No matter how large your cache you'll always come across tuples that are arbitrarily old and are from an unbounded size set of xids. We could replace the xids with a frozen xid sooner but that just amounts to nearly the same thing as the hint bits only with page locking and wal records. -- greg