diff options
| -rw-r--r-- | doc/TODO | 5 | ||||
| -rw-r--r-- | doc/src/FAQ/TODO.html | 5 |
2 files changed, 6 insertions, 4 deletions
@@ -2,7 +2,7 @@ PostgreSQL TODO List ==================== Current maintainer: Bruce Momjian (bruce@momjian.us) -Last updated: Tue Dec 12 15:34:25 EST 2006 +Last updated: Tue Dec 12 17:31:12 EST 2006 The most recent version of this document can be viewed at http://www.postgresql.org/docs/faqs.TODO.html. @@ -1187,7 +1187,8 @@ Optimizer / Executor * Precompile SQL functions to avoid overhead * Create utility to compute accurate random_page_cost value * Improve ability to display optimizer analysis using OPTIMIZER_DEBUG -* Have EXPLAIN ANALYZE highlight poor optimizer estimates +* Have EXPLAIN ANALYZE issue NOTICE messages when the estimated and + actual row counts differ by a specified percentage * Consider using hash buckets to do DISTINCT, rather than sorting This would be beneficial when there are few distinct values. This is diff --git a/doc/src/FAQ/TODO.html b/doc/src/FAQ/TODO.html index ff2662bd019..16f1682da72 100644 --- a/doc/src/FAQ/TODO.html +++ b/doc/src/FAQ/TODO.html @@ -8,7 +8,7 @@ <body bgcolor="#FFFFFF" text="#000000" link="#FF0000" vlink="#A00000" alink="#0000FF"> <h1><a name="section_1">PostgreSQL TODO List</a></h1> <p>Current maintainer: Bruce Momjian (<a href="mailto:bruce@momjian.us">bruce@momjian.us</a>)<br/> -Last updated: Tue Dec 12 15:34:25 EST 2006 +Last updated: Tue Dec 12 17:31:12 EST 2006 </p> <p>The most recent version of this document can be viewed at<br/> <a href="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>. @@ -1073,7 +1073,8 @@ first. </li><li>Precompile SQL functions to avoid overhead </li><li>Create utility to compute accurate random_page_cost value </li><li>Improve ability to display optimizer analysis using OPTIMIZER_DEBUG - </li><li>Have EXPLAIN ANALYZE highlight poor optimizer estimates + </li><li>Have EXPLAIN ANALYZE issue NOTICE messages when the estimated and + actual row counts differ by a specified percentage </li><li>Consider using hash buckets to do DISTINCT, rather than sorting <p> This would be beneficial when there are few distinct values. This is already used by GROUP BY. |