PostgreSQL TODO List

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

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

Last updated:Tue Jun14 19:44:43 EDT 2005

Last updated:Thu Jun16 22:20:43 EDT 2005

The most recent version of this document can be viewed at

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

This allows vacuum to target specific pages for possible free space

without requiring a sequential scan.

* Create a bitmap of pages that need vacuuming

Instead of sequentially scanning the entire table, have the background

writer or some other process record pages that have expired rows, then

VACUUM can look at just those pages rather than the entire table. In

the event of a system crash, the bitmap would probably be invalidated.

* Auto-vacuum

o Move into the backend code

o Scan the buffer cache to find free space or use background writer

<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:Tue Jun14 19:44:43 EDT 2005

Last updated:Thu Jun16 22:20:43 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><li>Maintain a map of recently-expired rows

<p> This allows vacuum to target specific pages for possible free space

without requiring a sequential scan.

</li><li>Create a bitmap of pages that need vacuuming

<p> Instead of sequentially scanning the entire table, have the background

writer or some other process record pages that have expired rows, then

VACUUM can look at just those pages rather than the entire table. In

the event of a system crash, the bitmap would probably be invalidated.

</li><li>Auto-vacuum