PostgreSQL TODO List

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

Current maintainer:Bruce Momjian (bruce@momjian.us)

Last updated:Mon Nov19 19:18:31 EST 2007

Last updated:Fri Nov23 11:37:47 EST 2007

The most recent version of this document can be viewed at

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

http://archives.postgresql.org/pgsql-patches/2007-03/msg00358.php

* -Reduce XID consumption of read-only queries

* Prevent long-lived temporary tables from causing frozen-Xid advancement

* Prevent long-lived temporary tables from causing frozen-xid advancement

starvation

The problem is that autovacuum cannot vacuum them to set frozen xids;

only the session that created them can do that.

* Auto-vacuum

o Use free-space map information to guide refilling

<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:bruce@momjian.us">bruce@momjian.us</a>)<br/>

Last updated:Mon Nov19 19:18:31 EST 2007

Last updated:Fri Nov23 11:37:47 EST 2007

<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>.

<p><ahref="http://archives.postgresql.org/pgsql-patches/2007-03/msg00358.php">http://archives.postgresql.org/pgsql-patches/2007-03/msg00358.php</a>

</li><li>-<em>Reduce XID consumption of read-only queries</em>

</li><li>Prevent long-lived temporary tables from causing frozen-Xid advancement

</li><li>Prevent long-lived temporary tables from causing frozen-xid advancement

starvation

</li><li>Auto-vacuum

<p> The problem is that autovacuum cannot vacuum them to set frozen xids;<br/>

only the session that created them can do that.

<li>Auto-vacuum

<li>Use free-space map information to guide refilling

</li><li>%Issue log message to suggest VACUUM FULL if a table is nearly