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

Commit4231931

Browse files
committed
Add:
> * Consider sorting hash buckets so entries can be found using a binary> search, rather than a linear scan> * In hash indexes, consider storing the hash value with or instead> of the key itself
1 parent770156e commit4231931

File tree

2 files changed

+10
-2
lines changed

2 files changed

+10
-2
lines changed

‎doc/TODO

Lines changed: 5 additions & 1 deletion
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:Fri May 27 18:01:15 EDT 2005
5+
Last updated:Fri May 27 18:07:21 EDT 2005
66

77
The most recent version of this document can be viewed at
88
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -351,6 +351,10 @@ Indexes
351351
several hash buckets could be stored on a single page and greater
352352
granularity used for the hash algorithm.
353353

354+
* Consider sorting hash buckets so entries can be found using a binary
355+
search, rather than a linear scan
356+
* In hash indexes, consider storing the hash value with or instead
357+
of the key itself
354358
* Allow accurate statistics to be collected on indexes with more than
355359
one column or expression indexes, perhaps using per-index statistics
356360
* Add fillfactor to control reserved free space during index creation

‎doc/src/FAQ/TODO.html

Lines changed: 5 additions & 1 deletion
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: Fri May 27 18:01:15 EDT 2005
11+
Last updated: Fri May 27 18:07:21 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>.
@@ -324,6 +324,10 @@ <h1><a name="section_6">Indexes</a></h1>
324324
several hash buckets could be stored on a single page and greater
325325
granularity used for the hash algorithm.
326326
</p>
327+
</li><li>Consider sorting hash buckets so entries can be found using a binary
328+
search, rather than a linear scan
329+
</li><li>In hash indexes, consider storing the hash value with or instead
330+
of the key itself
327331
</li><li>Allow accurate statistics to be collected on indexes with more than
328332
one column or expression indexes, perhaps using per-index statistics
329333
</li><li>Add fillfactor to control reserved free space during index creation

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp