diff options
| author | Itagaki Takahiro <itagaki.takahiro@gmail.com> | 2010-06-07 02:59:02 +0000 |
|---|---|---|
| committer | Itagaki Takahiro <itagaki.takahiro@gmail.com> | 2010-06-07 02:59:02 +0000 |
| commit | b5faba1284c4e5108c6fbe577daa33f933e7a4e0 (patch) | |
| tree | 86bb121d206f9369e8d744414c339826e1a54d83 /doc/src | |
| parent | 3fd839950a33a7d36ac83edf1f9cc6fb929d7649 (diff) | |
| download | postgresql-b5faba1284c4e5108c6fbe577daa33f933e7a4e0.tar.gz postgresql-b5faba1284c4e5108c6fbe577daa33f933e7a4e0.zip | |
Ensure default-only storage parameters for TOAST relations
to be initialized with proper values. Affected parameters are
fillfactor, analyze_threshold, and analyze_scale_factor.
Especially uninitialized fillfactor caused inefficient page usage
because we built a StdRdOptions struct in which fillfactor is zero
if any reloption is set for the toast table.
In addition, we disallow toast.autovacuum_analyze_threshold and
toast.autovacuum_analyze_scale_factor because we didn't actually
support them; they are always ignored.
Report by Rumko on pgsql-bugs on 12 May 2010.
Analysis by Tom Lane and Alvaro Herrera. Patch by me.
Backpatch to 8.4.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/create_table.sgml | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index d195c5de689..0c02d0cb919 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/create_table.sgml,v 1.127 2010/05/13 18:54:18 tgl Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/create_table.sgml,v 1.128 2010/06/07 02:59:02 itagaki Exp $ PostgreSQL documentation --> @@ -880,7 +880,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE <replaceable class="PAR </varlistentry> <varlistentry> - <term><literal>autovacuum_analyze_threshold</>, <literal>toast.autovacuum_analyze_threshold</literal> (<type>integer</>)</term> + <term><literal>autovacuum_analyze_threshold</> (<type>integer</>)</term> <listitem> <para> Minimum number of inserted, updated, or deleted tuples before initiate an @@ -890,7 +890,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE <replaceable class="PAR </varlistentry> <varlistentry> - <term><literal>autovacuum_analyze_scale_factor</>, <literal>toast.autovacuum_analyze_scale_factor</literal> (<type>float4</>)</term> + <term><literal>autovacuum_analyze_scale_factor</> (<type>float4</>)</term> <listitem> <para> Multiplier for <structfield>reltuples</> to add to |