|
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 Dec 1215:34:25 EST 2006 |
| 11 | +Last updated: Tue Dec 1217:31:12 EST 2006 |
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>. |
@@ -1073,7 +1073,8 @@ <h1><a name="section_19">Optimizer / Executor</a></h1> |
1073 | 1073 | </li><li>Precompile SQL functions to avoid overhead |
1074 | 1074 | </li><li>Create utility to compute accurate random_page_cost value |
1075 | 1075 | </li><li>Improve ability to display optimizer analysis using OPTIMIZER_DEBUG |
1076 | | -</li><li>Have EXPLAIN ANALYZE highlight poor optimizer estimates |
| 1076 | +</li><li>Have EXPLAIN ANALYZE issue NOTICE messages when the estimated and |
| 1077 | + actual row counts differ by a specified percentage |
1077 | 1078 | </li><li>Consider using hash buckets to do DISTINCT, rather than sorting |
1078 | 1079 | <p> This would be beneficial when there are few distinct values. This is |
1079 | 1080 | already used by GROUP BY. |
|