|
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 May 7 00:34:37 EDT 2008 |
| 11 | +Last updated: Wed May 7 00:45:30 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>.
|
@@ -1101,13 +1101,14 @@ <h1><a name="section_12">Indexes</a></h1>
|
1101 | 1101 | <p><ahref="http://archives.postgresql.org/pgsql-performance/2006-10/msg00222.php">http://archives.postgresql.org/pgsql-performance/2006-10/msg00222.php</a>
|
1102 | 1102 | <ahref="http://archives.postgresql.org/pgsql-hackers/2007-03/msg01131.php">http://archives.postgresql.org/pgsql-hackers/2007-03/msg01131.php</a>
|
1103 | 1103 | </p>
|
1104 |
| -</li><li>Consider increasing the number ofdefaultstatisticstarget, and |
1105 |
| - reduce statistics target overhead |
| 1104 | +</li><li>Consider increasing thedefault and maximumnumber of statisticstargets, |
| 1105 | +andreduce statistics target overhead |
1106 | 1106 | <p> Also consider having a larger statistics target for indexed columns
|
1107 | 1107 | and expression indexes
|
1108 | 1108 | <ahref="http://archives.postgresql.org/pgsql-general/2007-05/msg01228.php">http://archives.postgresql.org/pgsql-general/2007-05/msg01228.php</a>
|
1109 | 1109 | <ahref="http://archives.postgresql.org/pgsql-general/2007-06/msg00542.php">http://archives.postgresql.org/pgsql-general/2007-06/msg00542.php</a>
|
1110 | 1110 | <ahref="http://archives.postgresql.org/pgsql-hackers/2008-01/msg01066.php">http://archives.postgresql.org/pgsql-hackers/2008-01/msg01066.php</a>
|
| 1111 | +<ahref="http://archives.postgresql.org/pgsql-hackers/2008-03/msg00188.php">http://archives.postgresql.org/pgsql-hackers/2008-03/msg00188.php</a> |
1111 | 1112 | </p>
|
1112 | 1113 | </li><li>Consider smaller indexes that record a range of values per heap page,
|
1113 | 1114 | rather than having one index entry for every heap row
|
|