From 686968314775d72a5c073ce9037d34bc60fe956d Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sat, 23 Apr 2005 21:43:24 +0000 Subject: [PATCH] Remove item, not sure what it refers to: < * Allow ORDER BY ... LIMIT 1 to select high/low value without sort or < index using a sequential scan for highest/lowest values < < If only one value is needed, there is no need to sort the entire < table. Instead a sequential scan could get the matching value. < --- doc/TODO | 8 +------- doc/src/FAQ/TODO.html | 7 +------ 2 files changed, 2 insertions(+), 13 deletions(-) diff --git a/doc/TODO b/doc/TODO index f0e773cad7..97f5d5e41e 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: Sat Apr 23 17:41:00 EDT 2005 +Last updated: Sat Apr 23 17:43:18 EDT 2005 The most recent version of this document can be viewed at http://www.postgresql.org/docs/faqs.TODO.html. @@ -858,12 +858,6 @@ Optimizer / Executor ==================== * Add missing optimizer selectivities for date, r-tree, etc -* Allow ORDER BY ... LIMIT 1 to select high/low value without sort or - index using a sequential scan for highest/lowest values - - If only one value is needed, there is no need to sort the entire - table. Instead a sequential scan could get the matching value. - * Precompile SQL functions to avoid overhead * Create utility to compute accurate random_page_cost value * Improve ability to display optimizer analysis using OPTIMIZER_DEBUG diff --git a/doc/src/FAQ/TODO.html b/doc/src/FAQ/TODO.html index 978e57a626..e6daf79662 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: Sat Apr 23 17:41:00 EDT 2005 +Last updated: Sat Apr 23 17:43:18 EDT 2005

The most recent version of this document can be viewed at
http://www.postgresql.org/docs/faqs.TODO.html. @@ -782,11 +782,6 @@ first.