|
8 | 8 | <bodybgcolor="#FFFFFF"text="#000000"link="#FF0000"vlink="#A00000"alink="#0000FF">
|
9 | 9 | <h1><aname="section_1">PostgreSQL TODO List</a></h1>
|
10 | 10 | <p>Current maintainer: Bruce Momjian (<ahref="mailto:bruce@momjian.us">bruce@momjian.us</a>)<br/>
|
11 |
| -Last updated:Wed Apr23 22:24:23 EDT 2008 |
| 11 | +Last updated:Thu Apr24 11:53:48 EDT 2008 |
12 | 12 | </p>
|
13 | 13 | <p>The most recent version of this document can be viewed at<br/>
|
14 | 14 | <ahref="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>.
|
@@ -1090,9 +1090,10 @@ <h1><a name="section_12">Indexes</a></h1>
|
1090 | 1090 | <ahref="http://archives.postgresql.org/pgsql-general/2007-06/msg00542.php">http://archives.postgresql.org/pgsql-general/2007-06/msg00542.php</a>
|
1091 | 1091 | <ahref="http://archives.postgresql.org/pgsql-hackers/2008-01/msg01066.php">http://archives.postgresql.org/pgsql-hackers/2008-01/msg01066.php</a>
|
1092 | 1092 | </p>
|
1093 |
| -</li><li>Consider compressing indexes by storing key values duplicated in |
1094 |
| - several rows as a single index entry |
1095 |
| -<p><ahref="http://archives.postgresql.org/pgsql-hackers/2006-12/msg00341.php">http://archives.postgresql.org/pgsql-hackers/2006-12/msg00341.php</a> |
| 1093 | +</li><li>Consider smaller indexes that record a range of values per heap page, |
| 1094 | + rather than having one index entry for every heap row |
| 1095 | +<p> This is useful if the heap is clustered by the indexed values. |
| 1096 | +<ahref="http://archives.postgresql.org/pgsql-hackers/2006-12/msg00341.php">http://archives.postgresql.org/pgsql-hackers/2006-12/msg00341.php</a> |
1096 | 1097 | <ahref="http://archives.postgresql.org/pgsql-hackers/2007-02/msg01264.php">http://archives.postgresql.org/pgsql-hackers/2007-02/msg01264.php</a>
|
1097 | 1098 | <ahref="http://archives.postgresql.org/pgsql-hackers/2007-03/msg00465.php">http://archives.postgresql.org/pgsql-hackers/2007-03/msg00465.php</a>
|
1098 | 1099 | <ahref="http://archives.postgresql.org/pgsql-patches/2007-03/msg00163.php">http://archives.postgresql.org/pgsql-patches/2007-03/msg00163.php</a>
|
|