|
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: Tue Mar 11 14:14:49 EDT 2008 |
| 11 | +Last updated: Tue Mar 11 14:30:45 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>.
|
@@ -949,6 +949,11 @@ <h1><a name="section_12">Indexes</a></h1>
|
949 | 949 | one column or expression indexes, perhaps using per-index statistics
|
950 | 950 | <p><ahref="http://archives.postgresql.org/pgsql-performance/2006-10/msg00222.php">http://archives.postgresql.org/pgsql-performance/2006-10/msg00222.php</a>
|
951 | 951 | <ahref="http://archives.postgresql.org/pgsql-hackers/2007-03/msg01131.php">http://archives.postgresql.org/pgsql-hackers/2007-03/msg01131.php</a>
|
| 952 | +</p> |
| 953 | +</li><li>Consider increasing the number of default statistics target, and |
| 954 | + reduce statistics target overhead |
| 955 | +<p> Also consider having a larger statistics target for indexed columns |
| 956 | + and expression indexes |
952 | 957 | </p>
|
953 | 958 | </li><li>Consider compressing indexes by storing key values duplicated in
|
954 | 959 | several rows as a single index entry
|
|