Skip to content

Commit f0a2a91

Browse files
committed
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.
1 parent 1c88336 commit f0a2a91

File tree

2 files changed

+21
-2
lines changed

2 files changed

+21
-2
lines changed

doc/TODO

Lines changed: 10 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
PostgreSQL TODO List
33
====================
44
Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
5-
Last updated: Tue Jul 5 23:40:06 EDT 2005
5+
Last updated: Thu Jul 7 11:18:18 EDT 2005
66

77
The most recent version of this document can be viewed at
88
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -936,6 +936,15 @@ Write-Ahead Log
936936
partial page writes during recovery. These pages can also be
937937
eliminated from point-in-time archive files.
938938

939+
o -Add ability to turn off full page writes
940+
o When off, write CRC to WAL and check file system blocks
941+
on recovery
942+
o Write full pages during file system write and not when
943+
the page is modified in the buffer cache
944+
945+
This allows most full page writes to happen in the background
946+
writer.
947+
939948
* Reduce WAL traffic so only modified values are written rather than
940949
entire rows?
941950
* Add WAL index reliability improvement to non-btree indexes

doc/src/FAQ/TODO.html

Lines changed: 11 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
<body bgcolor="#FFFFFF" text="#000000" link="#FF0000" vlink="#A00000" alink="#0000FF">
99
<h1><a name="section_1">PostgreSQL TODO List</a></h1>
1010
<p>Current maintainer: Bruce Momjian (<a href="mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</a>)<br/>
11-
Last updated: Tue Jul 5 23:40:06 EDT 2005
11+
Last updated: Thu Jul 7 11:18:18 EDT 2005
1212
</p>
1313
<p>The most recent version of this document can be viewed at<br/>
1414
<a href="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>.
@@ -844,6 +844,16 @@ <h1><a name="section_19">Write-Ahead Log</a></h1>
844844
partial page writes during recovery. These pages can also be
845845
eliminated from point-in-time archive files.
846846
</p>
847+
<ul>
848+
<li>-Add ability to turn off full page writes
849+
</li><li>When off, write CRC to WAL and check file system blocks
850+
on recovery
851+
</li><li>Write full pages during file system write and not when
852+
the page is modified in the buffer cache
853+
<p> This allows most full page writes to happen in the background
854+
writer.
855+
</p>
856+
</li></ul>
847857
</li><li>Reduce WAL traffic so only modified values are written rather than
848858
entire rows?
849859
</li><li>Add WAL index reliability improvement to non-btree indexes

0 commit comments

Comments
 (0)