File tree Expand file tree Collapse file tree 2 files changed +9
-7
lines changed Expand file tree Collapse file tree 2 files changed +9
-7
lines changed Original file line number Diff line number Diff line change 1
1
PostgreSQL TODO List
2
2
====================
3
3
Current maintainer: Bruce Momjian (bruce@momjian.us)
4
- Last updated: Wed Apr 23 22:24:23 EDT 2008
4
+ Last updated: Thu Apr 24 11:53:48 EDT 2008
5
5
6
6
The most recent version of this document can be viewed at
7
7
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -1257,9 +1257,10 @@ Indexes
1257
1257
http://archives.postgresql.org/pgsql-general/2007-06/msg00542.php
1258
1258
http://archives.postgresql.org/pgsql-hackers/2008-01/msg01066.php
1259
1259
1260
- * Consider compressing indexes by storing key values duplicated in
1261
- several rows as a single index entry
1260
+ * Consider smaller indexes that record a range of values per heap page,
1261
+ rather than having one index entry for every heap row
1262
1262
1263
+ This is useful if the heap is clustered by the indexed values.
1263
1264
http://archives.postgresql.org/pgsql-hackers/2006-12/msg00341.php
1264
1265
http://archives.postgresql.org/pgsql-hackers/2007-02/msg01264.php
1265
1266
http://archives.postgresql.org/pgsql-hackers/2007-03/msg00465.php
Original file line number Diff line number Diff line change 8
8
< body bgcolor ="#FFFFFF " text ="#000000 " link ="#FF0000 " vlink ="#A00000 " alink ="#0000FF ">
9
9
< h1 > < a name ="section_1 "> PostgreSQL TODO List</ a > </ h1 >
10
10
< p > Current maintainer: Bruce Momjian (< a href ="mailto:bruce@momjian.us "> bruce@momjian.us</ a > )< br />
11
- Last updated: Wed Apr 23 22:24:23 EDT 2008
11
+ Last updated: Thu Apr 24 11:53:48 EDT 2008
12
12
</ p >
13
13
< p > The most recent version of this document can be viewed at< br />
14
14
< a href ="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>
1090
1090
< a href ="http://archives.postgresql.org/pgsql-general/2007-06/msg00542.php "> http://archives.postgresql.org/pgsql-general/2007-06/msg00542.php</ a >
1091
1091
< a href ="http://archives.postgresql.org/pgsql-hackers/2008-01/msg01066.php "> http://archives.postgresql.org/pgsql-hackers/2008-01/msg01066.php</ a >
1092
1092
</ p >
1093
- </ li > < li > Consider compressing indexes by storing key values duplicated in
1094
- several rows as a single index entry
1095
- < p > < a href ="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
+ < a href ="http://archives.postgresql.org/pgsql-hackers/2006-12/msg00341.php "> http://archives.postgresql.org/pgsql-hackers/2006-12/msg00341.php</ a >
1096
1097
< a href ="http://archives.postgresql.org/pgsql-hackers/2007-02/msg01264.php "> http://archives.postgresql.org/pgsql-hackers/2007-02/msg01264.php</ a >
1097
1098
< a href ="http://archives.postgresql.org/pgsql-hackers/2007-03/msg00465.php "> http://archives.postgresql.org/pgsql-hackers/2007-03/msg00465.php</ a >
1098
1099
< a href ="http://archives.postgresql.org/pgsql-patches/2007-03/msg00163.php "> http://archives.postgresql.org/pgsql-patches/2007-03/msg00163.php</ a >
You can’t perform that action at this time.
0 commit comments