PostgreSQL TODO List

====================

Current maintainer:Bruce Momjian (pgman@candle.pha.pa.us)

Last updated:Sat Jul2 10:30:35 EDT 2005

Last updated:Mon Jul4 00:06:35 EDT 2005

The most recent version of this document can be viewed at

http://www.postgresql.org/docs/faqs.TODO.html.

* Eliminate need to write full pages to WAL before page modification [wal]

Currently, to protect against partial disk page writes, we write the

Currently, to protect against partial disk page writes, we write

full page images to WAL before they are modified so we can correct any

partial page writes during recovery. These pages can also be

eliminated from point-in-time archive files.

* Reduce WAL traffic so only modified values are written rather than

entire rows (?)

* Turn offafter-change writes if fsync is disabled

* Turn offfull page writes if fsync is disabled

If fsync is off, there is no purpose in writing full pages to WAL

<bodybgcolor="#FFFFFF"text="#000000"link="#FF0000"vlink="#A00000"alink="#0000FF">

<h1><aname="section_1">PostgreSQL TODO List</a></h1>

<p>Current maintainer: Bruce Momjian (<ahref="mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</a>)<br/>

Last updated:Sat Jul2 10:30:35 EDT 2005

Last updated:Mon Jul4 00:06:35 EDT 2005

<p>The most recent version of this document can be viewed at<br/>

<ahref="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>.

<li>Eliminate need to write full pages to WAL before page modification [<ahref="http://momjian.postgresql.org/cgi-bin/pgtodo?wal">wal</a>]

<p> Currently, to protect against partial disk page writes, we write the

<p> Currently, to protect against partial disk page writes, we write

full page images to WAL before they are modified so we can correct any

partial page writes during recovery. These pages can also be

eliminated from point-in-time archive files.

</li><li>Reduce WAL traffic so only modified values are written rather than

entire rows (?)

</li><li>Turn offafter-change writes if fsync is disabled

</li><li>Turn offfull page writes if fsync is disabled

<p> If fsync is off, there is no purpose in writing full pages to WAL

</li><li>Add WAL index reliability improvement to non-btree indexes