From 8283cd7663ed098543361e102f40150ca2e3683c Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Tue, 12 Dec 2006 22:31:19 +0000 Subject: [PATCH] Update entry: < * 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 --- doc/TODO | 5 +++-- doc/src/FAQ/TODO.html | 5 +++-- 2 files changed, 6 insertions(+), 4 deletions(-) diff --git a/doc/TODO b/doc/TODO index 8d6483abaf..0a36c20f53 100644 --- a/doc/TODO +++ b/doc/TODO @@ -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 ff2662bd01..16f1682da7 100644 --- a/doc/src/FAQ/TODO.html +++ b/doc/src/FAQ/TODO.html @@ -8,7 +8,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. @@ -1073,7 +1073,8 @@ first.

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 already used by GROUP BY. -- 2.40.0