File tree Expand file tree Collapse file tree 2 files changed +13
-2
lines changed
Expand file tree Collapse file tree 2 files changed +13
-2
lines changed Original file line number Diff line number Diff line change 11PostgreSQL TODO List
22====================
33Current maintainer: Bruce Momjian (bruce@momjian.us)
4- Last updated: Tue Mar 11 14:14:49 EDT 2008
4+ Last updated: Tue Mar 11 14:30:45 EDT 2008
55
66The most recent version of this document can be viewed at
77http://www.postgresql.org/docs/faqs.TODO.html.
@@ -1085,6 +1085,12 @@ Indexes
10851085 http://archives.postgresql.org/pgsql-performance/2006-10/msg00222.php
10861086 http://archives.postgresql.org/pgsql-hackers/2007-03/msg01131.php
10871087
1088+ * Consider increasing the number of default statistics target, and
1089+ reduce statistics target overhead
1090+
1091+ Also consider having a larger statistics target for indexed columns
1092+ and expression indexes
1093+
10881094* Consider compressing indexes by storing key values duplicated in
10891095 several rows as a single index entry
10901096
Original file line number Diff line number Diff line change 88< body bgcolor ="#FFFFFF " text ="#000000 " link ="#FF0000 " vlink ="#A00000 " alink ="#0000FF ">
99< h1 > < a name ="section_1 "> PostgreSQL TODO List</ a > </ h1 >
1010< p > Current maintainer: Bruce Momjian (< a href ="mailto:bruce@momjian.us "> bruce@momjian.us</ a > )< br />
11- Last updated: Tue Mar 11 14:14:49 EDT 2008
11+ Last updated: Tue Mar 11 14:30:45 EDT 2008
1212</ p >
1313< p > The most recent version of this document can be viewed at< br />
1414< a href ="http://www.postgresql.org/docs/faqs.TODO.html "> http://www.postgresql.org/docs/faqs.TODO.html</ a > .
@@ -949,6 +949,11 @@ <h1><a name="section_12">Indexes</a></h1>
949949 one column or expression indexes, perhaps using per-index statistics
950950< p > < a href ="http://archives.postgresql.org/pgsql-performance/2006-10/msg00222.php "> http://archives.postgresql.org/pgsql-performance/2006-10/msg00222.php</ a >
951951 < a href ="http://archives.postgresql.org/pgsql-hackers/2007-03/msg01131.php "> http://archives.postgresql.org/pgsql-hackers/2007-03/msg01131.php</ a >
952+ </ p >
953+ </ li > < li > Consider increasing the number of default statistics target, and
954+ reduce statistics target overhead
955+ < p > Also consider having a larger statistics target for indexed columns
956+ and expression indexes
952957</ p >
953958 </ li > < li > Consider compressing indexes by storing key values duplicated in
954959 several rows as a single index entry
You can’t perform that action at this time.
0 commit comments