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

Commit9dd1049

Browse files
committed
Update TODO description for GIT:
* Consider smaller indexes that record a range of values per heap page, rather than having one index entry for every heap row
1 parent380d1ee commit9dd1049

File tree

2 files changed

+9
-7
lines changed

2 files changed

+9
-7
lines changed

‎doc/TODO

Lines changed: 4 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11
PostgreSQL TODO List
22
====================
33
Current maintainer:Bruce Momjian (bruce@momjian.us)
4-
Last updated:Wed Apr23 22:24:23 EDT 2008
4+
Last updated:Thu Apr24 11:53:48 EDT 2008
55

66
The most recent version of this document can be viewed at
77
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -1257,9 +1257,10 @@ Indexes
12571257
http://archives.postgresql.org/pgsql-general/2007-06/msg00542.php
12581258
http://archives.postgresql.org/pgsql-hackers/2008-01/msg01066.php
12591259

1260-
* Considercompressing indexesby storing keyvaluesduplicated in
1261-
several rows as a singleindex entry
1260+
* Considersmaller indexesthat record a range ofvaluesper heap page,
1261+
rather than having oneindex entry for every heap row
12621262

1263+
This is useful if the heap is clustered by the indexed values.
12631264
http://archives.postgresql.org/pgsql-hackers/2006-12/msg00341.php
12641265
http://archives.postgresql.org/pgsql-hackers/2007-02/msg01264.php
12651266
http://archives.postgresql.org/pgsql-hackers/2007-03/msg00465.php

‎doc/src/FAQ/TODO.html

Lines changed: 5 additions & 4 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:Wed Apr23 22:24:23 EDT 2008
11+
Last updated:Thu Apr24 11:53:48 EDT 2008
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>.
@@ -1090,9 +1090,10 @@ <h1><a name="section_12">Indexes</a></h1>
10901090
<ahref="http://archives.postgresql.org/pgsql-general/2007-06/msg00542.php">http://archives.postgresql.org/pgsql-general/2007-06/msg00542.php</a>
10911091
<ahref="http://archives.postgresql.org/pgsql-hackers/2008-01/msg01066.php">http://archives.postgresql.org/pgsql-hackers/2008-01/msg01066.php</a>
10921092
</p>
1093-
</li><li>Consider compressing indexes by storing key values duplicated in
1094-
several rows as a single index entry
1095-
<p><ahref="http://archives.postgresql.org/pgsql-hackers/2006-12/msg00341.php">http://archives.postgresql.org/pgsql-hackers/2006-12/msg00341.php</a>
1093+
</li><li>Consider smaller indexes that record a range of values per heap page,
1094+
rather than having one index entry for every heap row
1095+
<p> This is useful if the heap is clustered by the indexed values.
1096+
<ahref="http://archives.postgresql.org/pgsql-hackers/2006-12/msg00341.php">http://archives.postgresql.org/pgsql-hackers/2006-12/msg00341.php</a>
10961097
<ahref="http://archives.postgresql.org/pgsql-hackers/2007-02/msg01264.php">http://archives.postgresql.org/pgsql-hackers/2007-02/msg01264.php</a>
10971098
<ahref="http://archives.postgresql.org/pgsql-hackers/2007-03/msg00465.php">http://archives.postgresql.org/pgsql-hackers/2007-03/msg00465.php</a>
10981099
<ahref="http://archives.postgresql.org/pgsql-patches/2007-03/msg00163.php">http://archives.postgresql.org/pgsql-patches/2007-03/msg00163.php</a>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp