diff options
| author | Bruce Momjian <bruce@momjian.us> | 2005-07-07 15:18:26 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2005-07-07 15:18:26 +0000 |
| commit | f0a2a919181e2dd5c564e0df2f04a7cf00b21043 (patch) | |
| tree | 382af1559ec755c46cee8b7a807186c4e75711b4 | |
| parent | 1c883366efd8ea5dd1b879dd849ec3139676f662 (diff) | |
| download | postgresql-f0a2a919181e2dd5c564e0df2f04a7cf00b21043.tar.gz | |
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.
| -rw-r--r-- | doc/TODO | 11 | ||||
| -rw-r--r-- | doc/src/FAQ/TODO.html | 12 |
2 files changed, 21 insertions, 2 deletions
@@ -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 924570dc11..6b2b48be11 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 |