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

Commitd14ca04

Browse files
committed
Add:
>> * Consider increasing the number of default statistics target, and> reduce statistics target overhead>> Also consider having a larger statistics target for indexed columns> and expression indexes
1 parent3879b62 commitd14ca04

File tree

2 files changed

+13
-2
lines changed

2 files changed

+13
-2
lines changed

‎doc/TODO

Lines changed: 7 additions & 1 deletion
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:Tue Mar 11 14:14:49 EDT 2008
4+
Last updated:Tue Mar 11 14:30:45 EDT 2008
55

66
The most recent version of this document can be viewed at
77
http://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

‎doc/src/FAQ/TODO.html

Lines changed: 6 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: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
<ahref="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><ahref="http://archives.postgresql.org/pgsql-performance/2006-10/msg00222.php">http://archives.postgresql.org/pgsql-performance/2006-10/msg00222.php</a>
951951
<ahref="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

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp