PostgreSQL TODO List

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

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

Last updated:Tue Jan 30 22:07:21 EST 2007

Last updated:Tue Jan 30 22:17:43 EST 2007

The most recent version of this document can be viewed at

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

This is difficult because it requires datatype-specific knowledge.

* Add REINDEX CONCURRENTLY, like CREATE INDEX CONCURRENTLY

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

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

have this complication. This would allow index compaction without

downtime.

* Inheritance

<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: Tue Jan 30 22:07:21 EST 2007

Last updated: Tue Jan 30 22:17:43 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>.

</li><li>Consider compressing indexes by storing key values duplicated in

several rows as a single index entry

<p> This is difficult because it requires datatype-specific knowledge.

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

have this complication. This would allow index compaction without

downtime.

</li><li>Inheritance