From e5c7c05168fd22be164001b5cfb9512b1d919008 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Wed, 20 Apr 2005 02:43:49 +0000 Subject: [PATCH] Add: > * Log queries where the optimizer row estimates were dramatically > different from the number of rows actually found (?) --- doc/TODO | 4 +++- doc/src/FAQ/TODO.html | 4 +++- 2 files changed, 6 insertions(+), 2 deletions(-) diff --git a/doc/TODO b/doc/TODO index 71a70a6056..1451aeaf3e 100644 --- a/doc/TODO +++ b/doc/TODO @@ -2,7 +2,7 @@ PostgreSQL TODO List ==================== Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) -Last updated: Tue Apr 19 21:17:33 EDT 2005 +Last updated: Tue Apr 19 22:43:50 EDT 2005 The most recent version of this document can be viewed at the PostgreSQL web site, http://www.PostgreSQL.org. @@ -879,6 +879,8 @@ Optimizer / Executor This would be beneficial when there are few distinct values. * ANALYZE should record a pg_statistic entry for an all-NULL column +* Log queries where the optimizer row estimates were dramatically + different from the number of rows actually found (?) Miscellaneous diff --git a/doc/src/FAQ/TODO.html b/doc/src/FAQ/TODO.html index 20f7dc8ddc..14d6b291c7 100644 --- a/doc/src/FAQ/TODO.html +++ b/doc/src/FAQ/TODO.html @@ -8,7 +8,7 @@

PostgreSQL TODO List

Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
-Last updated: Tue Apr 19 21:17:33 EDT 2005 +Last updated: Tue Apr 19 22:43:50 EDT 2005

The most recent version of this document can be viewed at the PostgreSQL web
site, http://www.PostgreSQL.org. @@ -800,6 +800,8 @@ first.

This would be beneficial when there are few distinct values.

  • ANALYZE should record a pg_statistic entry for an all-NULL column +
  • Log queries where the optimizer row estimates were dramatically + different from the number of rows actually found (?)

    • Miscellaneous

    -- 2.40.0