PostgreSQL TODO List

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

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

Last updated:Thu Mar 6 17:04:50 EST 2008

Last updated:Thu Mar 6 17:09:38 EST 2008

The most recent version of this document can be viewed at

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

* Consider compressing indexes by storing key values duplicated in

several rows as a single index entry

http://archives.postgresql.org/pgsql-hackers/2006-12/msg00341.php

http://archives.postgresql.org/pgsql-hackers/2007-02/msg01264.php

http://archives.postgresql.org/pgsql-hackers/2007-03/msg00465.php

* Add REINDEX CONCURRENTLY, like CREATE INDEX CONCURRENTLY

This is difficult because you must upgrade to an exclusive table lock

<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: Thu Mar 6 17:04:50 EST 2008

Last updated: Thu Mar 6 17:09:38 EST 2008

<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>Consider compressing indexes by storing key values duplicated in

several rows as a single index entry

<p><ahref="http://archives.postgresql.org/pgsql-hackers/2006-12/msg00341.php">http://archives.postgresql.org/pgsql-hackers/2006-12/msg00341.php</a>

<ahref="http://archives.postgresql.org/pgsql-hackers/2007-02/msg01264.php">http://archives.postgresql.org/pgsql-hackers/2007-02/msg01264.php</a>

<ahref="http://archives.postgresql.org/pgsql-hackers/2007-03/msg00465.php">http://archives.postgresql.org/pgsql-hackers/2007-03/msg00465.php</a>

</li><li>Add REINDEX CONCURRENTLY, like CREATE INDEX CONCURRENTLY

<p> This is difficult because you must upgrade to an exclusive table lock

to replace the existing index file. CREATE INDEX CONCURRENTLY does not