From 634b1614a05edc0cf2b70097818dba5a9314fc27 Mon Sep 17 00:00:00 2001 From: Itagaki Takahiro Date: Mon, 7 Jun 2010 03:01:35 +0000 Subject: 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. --- doc/src/sgml/ref/create_table.sgml | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index 1d0b8a4904f..01270faf4c6 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -1,5 +1,5 @@ @@ -770,7 +770,7 @@ and table_constraint is: - autovacuum_analyze_threshold, toast.autovacuum_analyze_threshold (integer) + autovacuum_analyze_threshold (integer) Minimum number of inserted, updated, or deleted tuples before initiate an @@ -780,7 +780,7 @@ and table_constraint is: - autovacuum_analyze_scale_factor, toast.autovacuum_analyze_scale_factor (float4) + autovacuum_analyze_scale_factor (float4) Multiplier for reltuples to add to -- cgit v1.2.3