postgres.git / summary / log / commit / refs

commit    f0a2a919181e2dd5c564e0df2f04a7cf00b21043
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Thu Jul 07 15:18:26 2005 +0000
First released in: 8.1.0

    Update:
    
    >
    > 	o  -Add ability to turn off full page writes
    > 	o  When off, write CRC to WAL and check file system blocks
    > 	   on recovery
    > 	o  Write full pages during file system write and not when
    > 	   the page is modified in the buffer cache
    >
    > 	   This allows most full page writes to happen in the background
    > 	   writer.


doc/TODO | 11 ++++++++++- doc/src/FAQ/TODO.html | 12 +++++++++++- 2 files changed, 21 insertions(+), 2 deletions(-) diff --git a/doc/TODO b/doc/TODO index d9d7113d770..a9691bf7a70 100644 --- a/doc/TODO +++ b/doc/TODO @@ -2,7 +2,7 @@ PostgreSQL TODO List ==================== Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) -Last updated: Tue Jul 5 23:40:06 EDT 2005 +Last updated: Thu Jul 7 11:18:18 EDT 2005 The most recent version of this document can be viewed at http://www.postgresql.org/docs/faqs.TODO.html. @@ -936,6 +936,15 @@ Write-Ahead Log partial page writes during recovery. These pages can also be eliminated from point-in-time archive files. + o -Add ability to turn off full page writes + o When off, write CRC to WAL and check file system blocks + on recovery + o Write full pages during file system write and not when + the page is modified in the buffer cache + + This allows most full page writes to happen in the background + writer. + * Reduce WAL traffic so only modified values are written rather than entire rows? * Add WAL index reliability improvement to non-btree indexes diff --git a/doc/src/FAQ/TODO.html b/doc/src/FAQ/TODO.html index 924570dc118..6b2b48be119 100644 --- a/doc/src/FAQ/TODO.html +++ b/doc/src/FAQ/TODO.html @@ -8,7 +8,7 @@ <body bgcolor="#FFFFFF" text="#000000" link="#FF0000" vlink="#A00000" alink="#0000FF"> <h1><a name="section_1">PostgreSQL TODO List</a></h1> <p>Current maintainer: Bruce Momjian (<a href="mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</a>)<br/> -Last updated: Tue Jul 5 23:40:06 EDT 2005 +Last updated: Thu Jul 7 11:18:18 EDT 2005 </p> <p>The most recent version of this document can be viewed at<br/> <a href="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>. @@ -844,6 +844,16 @@ first. partial page writes during recovery. These pages can also be eliminated from point-in-time archive files. </p> + <ul> + <li>-Add ability to turn off full page writes + </li><li>When off, write CRC to WAL and check file system blocks + on recovery + </li><li>Write full pages during file system write and not when + the page is modified in the buffer cache +<p> This allows most full page writes to happen in the background + writer. +</p> + </li></ul> </li><li>Reduce WAL traffic so only modified values are written rather than entire rows? </li><li>Add WAL index reliability improvement to non-btree indexes [parent: 1c883366efd8]