Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit6869683

Browse files
committed
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.<
1 parent1207d5b commit6869683

File tree

2 files changed

+2
-13
lines changed

2 files changed

+2
-13
lines changed

‎doc/TODO

Lines changed: 1 addition & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
PostgreSQL TODO List
33
====================
44
Current maintainer:Bruce Momjian (pgman@candle.pha.pa.us)
5-
Last updated:Sat Apr 23 17:41:00 EDT 2005
5+
Last updated:Sat Apr 23 17:43:18 EDT 2005
66

77
The most recent version of this document can be viewed at
88
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -858,12 +858,6 @@ Optimizer / Executor
858858
====================
859859

860860
* Add missing optimizer selectivities for date, r-tree, etc
861-
* Allow ORDER BY ... LIMIT 1 to select high/low value without sort or
862-
index using a sequential scan for highest/lowest values
863-
864-
If only one value is needed, there is no need to sort the entire
865-
table. Instead a sequential scan could get the matching value.
866-
867861
* Precompile SQL functions to avoid overhead
868862
* Create utility to compute accurate random_page_cost value
869863
* Improve ability to display optimizer analysis using OPTIMIZER_DEBUG

‎doc/src/FAQ/TODO.html

Lines changed: 1 addition & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
<bodybgcolor="#FFFFFF"text="#000000"link="#FF0000"vlink="#A00000"alink="#0000FF">
99
<h1><aname="section_1">PostgreSQL TODO List</a></h1>
1010
<p>Current maintainer: Bruce Momjian (<ahref="mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</a>)<br/>
11-
Last updated: Sat Apr 23 17:41:00 EDT 2005
11+
Last updated: Sat Apr 23 17:43:18 EDT 2005
1212
</p>
1313
<p>The most recent version of this document can be viewed at<br/>
1414
<ahref="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>.
@@ -782,11 +782,6 @@ <h1><a name="section_18">Optimizer / Executor</a></h1>
782782

783783
<ul>
784784
<li>Add missing optimizer selectivities for date, r-tree, etc
785-
</li><li>Allow ORDER BY ... LIMIT 1 to select high/low value without sort or
786-
index using a sequential scan for highest/lowest values
787-
<p> If only one value is needed, there is no need to sort the entire
788-
table. Instead a sequential scan could get the matching value.
789-
</p>
790785
</li><li>Precompile SQL functions to avoid overhead
791786
</li><li>Create utility to compute accurate random_page_cost value
792787
</li><li>Improve ability to display optimizer analysis using OPTIMIZER_DEBUG

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp