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

Commit8283cd7

Browse files
committed
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
1 parentf18c57f commit8283cd7

File tree

2 files changed

+6
-4
lines changed

2 files changed

+6
-4
lines changed

‎doc/TODO

Lines changed: 3 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
PostgreSQL TODO List
33
====================
44
Current maintainer:Bruce Momjian (bruce@momjian.us)
5-
Last updated:Tue Dec 1215:34:25 EST 2006
5+
Last updated:Tue Dec 1217:31:12 EST 2006
66

77
The most recent version of this document can be viewed at
88
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -1187,7 +1187,8 @@ Optimizer / Executor
11871187
* Precompile SQL functions to avoid overhead
11881188
* Create utility to compute accurate random_page_cost value
11891189
* Improve ability to display optimizer analysis using OPTIMIZER_DEBUG
1190-
* Have EXPLAIN ANALYZE highlight poor optimizer estimates
1190+
* Have EXPLAIN ANALYZE issue NOTICE messages when the estimated and
1191+
actual row counts differ by a specified percentage
11911192
* Consider using hash buckets to do DISTINCT, rather than sorting
11921193

11931194
This would be beneficial when there are few distinct values. This is

‎doc/src/FAQ/TODO.html

Lines changed: 3 additions & 2 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:bruce@momjian.us">bruce@momjian.us</a>)<br/>
11-
Last updated: Tue Dec 1215:34:25 EST 2006
11+
Last updated: Tue Dec 1217:31:12 EST 2006
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>.
@@ -1073,7 +1073,8 @@ <h1><a name="section_19">Optimizer / Executor</a></h1>
10731073
</li><li>Precompile SQL functions to avoid overhead
10741074
</li><li>Create utility to compute accurate random_page_cost value
10751075
</li><li>Improve ability to display optimizer analysis using OPTIMIZER_DEBUG
1076-
</li><li>Have EXPLAIN ANALYZE highlight poor optimizer estimates
1076+
</li><li>Have EXPLAIN ANALYZE issue NOTICE messages when the estimated and
1077+
actual row counts differ by a specified percentage
10771078
</li><li>Consider using hash buckets to do DISTINCT, rather than sorting
10781079
<p> This would be beneficial when there are few distinct values. This is
10791080
already used by GROUP BY.

0 commit comments

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