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