diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2007-07-24 01:53:56 +0000 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2007-07-24 01:53:56 +0000 |
| commit | 53d2951be7687089885865f31949eda87439a80b (patch) | |
| tree | ce5cfa88e8702a50de1238eb4c8455ef38c6a7e5 /doc/src | |
| parent | ab7d2b6a7376a7a3542201899aff9e953414ca81 (diff) | |
Set a default autovacuum vacuum_cost_delay value of 20ms, to avoid excessive
I/O utilization, per discussion.
While at it, lower the autovacuum vacuum and analyze threshold values to 50
tuples. It is a bit higher (i.e. more conservative) than what I originally
proposed but much better than the old values for small tables.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/config.sgml | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index b001e5f283c..a3331bdef6e 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.131 2007/07/18 12:00:47 mha Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.132 2007/07/24 01:53:55 alvherre Exp $ --> <chapter Id="runtime-config"> <title>Server Configuration</title> @@ -3247,7 +3247,7 @@ SELECT * FROM parent WHERE key = 2400; <para> Specifies the minimum number of updated or deleted tuples needed to trigger a <command>VACUUM</> in any one table. - The default is 500 tuples. + The default is 50 tuples. This parameter can only be set in the <filename>postgresql.conf</> file or on the server command line. This setting can be overridden for individual tables by entries in @@ -3265,7 +3265,7 @@ SELECT * FROM parent WHERE key = 2400; <para> Specifies the minimum number of inserted, updated or deleted tuples needed to trigger an <command>ANALYZE</> in any one table. - The default is 250 tuples. + The default is 50 tuples. This parameter can only be set in the <filename>postgresql.conf</> file or on the server command line. This setting can be overridden for individual tables by entries in @@ -3343,8 +3343,9 @@ SELECT * FROM parent WHERE key = 2400; <para> Specifies the cost delay value that will be used in automatic <command>VACUUM</> operations. If <literal>-1</> is - specified (which is the default), the regular + specified, the regular <xref linkend="guc-vacuum-cost-delay"> value will be used. + The default value is 20 milliseconds. This parameter can only be set in the <filename>postgresql.conf</> file or on the server command line. This setting can be overridden for individual tables by entries in |