Euler Taveira de Oliveira escribió: > (i) I don't like this construction "by entries by changing storage > parameters". I prefer "by changing storage parameters" or "by entries in > pg_class.reloptions";
Heh, obvious "by entries by" is a cut'n'pasto; fixed. Maybe an xref would be better there. I attach the doc patch again; I fiddled a bit with it this morning. Comments? > (ii) I think we should change the expression "storage parameters" for > something else because autovacuum is related to maintenance. My suggestion is > a general expression like "relation parameters"; I'm not sure I agree with this idea, because the term "storage parameter" has been used for several releases already. This would be a relatively major terminology change. > (iii) I noticed that GUC defaults and relopt defaults are different > (autovacuum_cost_delay and autovacuum_cost_limit). Is there any reason for not > using -1? Yeah, -1 does not make sense. It made sense in pg_autovacuum because otherwise you didn't have to specify "skip this setting and use the default". In reloptions, if you don't want to specify the setting, just don't specify it. > (iv) Maybe we should document that pg_dump will only dump reloptions like > toast.foo iff the relation has an associated TOAST table. This seems obvious > but ... Well, if it doesn't have a toast table, then there's no need for toast settings, is there? I mean, you could construe it as a gotcha: if you CREATE TABLE with only fixed-length columns and specify some reloptions, and later add a column that requires a toast table, it won't have the options you set at CREATE time. However, it seems to me to be very low in the importance scale. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.
*** doc/src/sgml/catalogs.sgml 4 Feb 2009 21:30:41 -0000 2.194 --- doc/src/sgml/catalogs.sgml 5 Feb 2009 18:32:40 -0000 *************** *** 89,99 **** </row> <row> - <entry><link linkend="catalog-pg-autovacuum"><structname>pg_autovacuum</structname></link></entry> - <entry>per-relation autovacuum configuration parameters</entry> - </row> - - <row> <entry><link linkend="catalog-pg-cast"><structname>pg_cast</structname></link></entry> <entry>casts (data type conversions)</entry> </row> --- 89,94 ---- *************** *** 1256,1433 **** </sect1> - <sect1 id="catalog-pg-autovacuum"> - <title><structname>pg_autovacuum</structname></title> - - <indexterm zone="catalog-pg-autovacuum"> - <primary>pg_autovacuum</primary> - </indexterm> - - <indexterm zone="catalog-pg-autovacuum"> - <primary>autovacuum</primary> - <secondary>table-specific configuration</secondary> - </indexterm> - - <para> - The catalog <structname>pg_autovacuum</structname> stores optional - per-relation configuration parameters for the autovacuum daemon. - If there is an entry here for a particular relation, the given - parameters will be used for autovacuuming that table. If no entry - is present, the system-wide defaults will be used. For more information - about the autovacuum daemon, see <xref linkend="autovacuum">. - </para> - - <note> - <para> - It is likely that <structname>pg_autovacuum</structname> will disappear - in a future release, with the information instead being kept in - <structname>pg_class</>.<structfield>reloptions</> entries. - </para> - </note> - - <table> - <title><structname>pg_autovacuum</> Columns</title> - - <tgroup cols="4"> - <thead> - <row> - <entry>Name</entry> - <entry>Type</entry> - <entry>References</entry> - <entry>Description</entry> - </row> - </thead> - - <tbody> - <row> - <entry><structfield>vacrelid</structfield></entry> - <entry><type>oid</type></entry> - <entry><literal><link linkend="catalog-pg-class"><structname>pg_class</structname></link>.oid</literal></entry> - <entry>The table this entry is for</entry> - </row> - - <row> - <entry><structfield>enabled</structfield></entry> - <entry><type>bool</type></entry> - <entry></entry> - <entry>If false, this table will not be autovacuumed, except - to prevent transaction ID wraparound</entry> - </row> - - <row> - <entry><structfield>vac_base_thresh</structfield></entry> - <entry><type>integer</type></entry> - <entry></entry> - <entry>Minimum number of modified tuples before vacuum</entry> - </row> - - <row> - <entry><structfield>vac_scale_factor</structfield></entry> - <entry><type>float4</type></entry> - <entry></entry> - <entry>Multiplier for <structfield>reltuples</> to add to - <structfield>vac_base_thresh</></entry> - </row> - - <row> - <entry><structfield>anl_base_thresh</structfield></entry> - <entry><type>integer</type></entry> - <entry></entry> - <entry>Minimum number of modified tuples before analyze</entry> - </row> - - <row> - <entry><structfield>anl_scale_factor</structfield></entry> - <entry><type>float4</type></entry> - <entry></entry> - <entry>Multiplier for <structfield>reltuples</> to add to - <structfield>anl_base_thresh</></entry> - </row> - - <row> - <entry><structfield>vac_cost_delay</structfield></entry> - <entry><type>integer</type></entry> - <entry></entry> - <entry>Custom <varname>vacuum_cost_delay</> parameter</entry> - </row> - - <row> - <entry><structfield>vac_cost_limit</structfield></entry> - <entry><type>integer</type></entry> - <entry></entry> - <entry>Custom <varname>vacuum_cost_limit</> parameter</entry> - </row> - - <row> - <entry><structfield>freeze_min_age</structfield></entry> - <entry><type>integer</type></entry> - <entry></entry> - <entry>Custom <varname>vacuum_freeze_min_age</> parameter</entry> - </row> - - <row> - <entry><structfield>freeze_max_age</structfield></entry> - <entry><type>integer</type></entry> - <entry></entry> - <entry>Custom <varname>autovacuum_freeze_max_age</> parameter</entry> - </row> - - <row> - <entry><structfield>freeze_table_age</structfield></entry> - <entry><type>integer</type></entry> - <entry></entry> - <entry>Custom <varname>vacuum_freeze_table_age</> parameter</entry> - </row> - </tbody> - </tgroup> - </table> - - <para> - The autovacuum daemon will initiate a <command>VACUUM</> operation - on a particular table when the number of updated or deleted tuples - exceeds <structfield>vac_base_thresh</structfield> plus - <structfield>vac_scale_factor</structfield> times the number of - live tuples currently estimated to be in the relation. - Similarly, it will initiate an <command>ANALYZE</> operation - when the number of inserted, updated or deleted tuples - exceeds <structfield>anl_base_thresh</structfield> plus - <structfield>anl_scale_factor</structfield> times the number of - live tuples currently estimated to be in the relation. - </para> - - <para> - Also, the autovacuum daemon will perform a <command>VACUUM</> operation - to prevent transaction ID wraparound if the table's - <structname>pg_class</>.<structfield>relfrozenxid</> field attains an age - of more than <structfield>freeze_max_age</> transactions, whether the table - has been changed or not, even if - <structname>pg_autovacuum</>.<structfield>enabled</> is set to - <literal>false</> for it. The system will launch autovacuum to perform - such <command>VACUUM</>s even if autovacuum is otherwise disabled. - See <xref linkend="vacuum-for-wraparound"> for more about wraparound - prevention. - </para> - - <para> - Any of the numerical fields can contain <literal>-1</> (or indeed - any negative value) to indicate that the system-wide default should - be used for this particular value. Observe that the - <structfield>vac_cost_delay</> variable inherits its default value from the - <xref linkend="guc-autovacuum-vacuum-cost-delay"> configuration parameter, - or from <xref linkend="guc-vacuum-cost-delay"> if the former is set to a - negative value. The same applies to <structfield>vac_cost_limit</>. - Also, autovacuum will ignore attempts to set a per-table - <structfield>freeze_max_age</> larger than the system-wide setting (it can - only be set smaller), and the <structfield>freeze_min_age</> value will be - limited to half the system-wide <xref - linkend="guc-autovacuum-freeze-max-age"> setting. Note that while you - can set <structfield>freeze_max_age</> very small, or even zero, this - is usually unwise since it will force frequent vacuuming. - </para> - - </sect1> - - <sect1 id="catalog-pg-cast"> <title><structname>pg_cast</structname></title> --- 1251,1256 ---- *** doc/src/sgml/config.sgml 16 Jan 2009 13:27:23 -0000 1.206 --- doc/src/sgml/config.sgml 6 Feb 2009 17:27:58 -0000 *************** *** 3547,3554 **** 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 ! <structname>pg_autovacuum</>. </para> </listitem> </varlistentry> --- 3547,3554 ---- 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 ! changing storage parameters. </para> </listitem> </varlistentry> *************** *** 3565,3572 **** 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 ! <structname>pg_autovacuum</>. </para> </listitem> </varlistentry> --- 3565,3572 ---- 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 ! changing storage parameters. </para> </listitem> </varlistentry> *************** *** 3584,3591 **** The default is 0.2 (20% of table size). 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 ! <structname>pg_autovacuum</>. </para> </listitem> </varlistentry> --- 3584,3591 ---- The default is 0.2 (20% of table size). 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 ! changing storage parameters. </para> </listitem> </varlistentry> *************** *** 3603,3610 **** The default is 0.1 (10% of table size). 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 ! <structname>pg_autovacuum</>. </para> </listitem> </varlistentry> --- 3603,3610 ---- The default is 0.1 (10% of table size). 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 ! changing storage parameters. </para> </listitem> </varlistentry> *************** *** 3624,3631 **** autovacuum is otherwise disabled. The default is 200 million transactions. This parameter can only be set at server start, but the setting ! can be reduced for individual tables by entries in ! <structname>pg_autovacuum</>. For more information see <xref linkend="vacuum-for-wraparound">. </para> </listitem> --- 3624,3631 ---- autovacuum is otherwise disabled. The default is 200 million transactions. This parameter can only be set at server start, but the setting ! can be reduced for individual tables by ! changing storage parameters. For more information see <xref linkend="vacuum-for-wraparound">. </para> </listitem> *************** *** 3645,3652 **** 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 ! <structname>pg_autovacuum</>. </para> </listitem> </varlistentry> --- 3645,3652 ---- 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 ! changing storage parameters. </para> </listitem> </varlistentry> *************** *** 3667,3674 **** each worker never exceeds the limit on this variable. 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 ! <structname>pg_autovacuum</>. </para> </listitem> </varlistentry> --- 3667,3674 ---- each worker never exceeds the limit on this variable. 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 ! changing storage parameters. </para> </listitem> </varlistentry> *** doc/src/sgml/maintenance.sgml 16 Jan 2009 13:27:23 -0000 1.89 --- doc/src/sgml/maintenance.sgml 6 Feb 2009 14:26:44 -0000 *************** *** 573,579 **** <para> Tables whose <structfield>relfrozenxid</> value is more than <varname>autovacuum_freeze_max_age</> transactions old are always ! vacuumed. Otherwise, if the number of tuples obsoleted since the last <command>VACUUM</command> exceeds the <quote>vacuum threshold</quote>, the table is vacuumed. The vacuum threshold is defined as: <programlisting> --- 573,581 ---- <para> Tables whose <structfield>relfrozenxid</> value is more than <varname>autovacuum_freeze_max_age</> transactions old are always ! vacuumed (this also applies to those tables whose freeze max age has ! been modified via storage parameters; see below). Otherwise, if the ! number of tuples obsoleted since the last <command>VACUUM</command> exceeds the <quote>vacuum threshold</quote>, the table is vacuumed. The vacuum threshold is defined as: <programlisting> *************** *** 604,669 **** <para> The default thresholds and scale factors are taken from <filename>postgresql.conf</filename>, but it is possible to override them ! on a table-by-table basis by making entries in the system catalog ! <link ! linkend="catalog-pg-autovacuum"><structname>pg_autovacuum</></link>. ! If a <structname>pg_autovacuum</structname> row exists for a particular ! table, the settings it specifies are applied; otherwise the global ! settings are used. See <xref linkend="runtime-config-autovacuum"> for more details on the global settings. </para> <para> ! Besides the base threshold values and scale factors, there are five ! more parameters that can be set for each table in ! <structname>pg_autovacuum</structname>. ! The first, <structname>pg_autovacuum</>.<structfield>enabled</>, can be set to <literal>false</literal> to instruct the autovacuum daemon to skip that particular table entirely. In this case autovacuum will only touch the table if it must do so to prevent transaction ID wraparound. ! The next two parameters, the vacuum cost delay ! (<structname>pg_autovacuum</structname>.<structfield>vac_cost_delay</structfield>) ! and the vacuum cost limit ! (<structname>pg_autovacuum</structname>.<structfield>vac_cost_limit</structfield>), ! are used to set table-specific values for the ! <xref linkend="runtime-config-resource-vacuum-cost" endterm="runtime-config-resource-vacuum-cost-title"> feature. ! The last two parameters, ! (<structname>pg_autovacuum</structname>.<structfield>freeze_min_age</structfield>) ! and ! (<structname>pg_autovacuum</structname>.<structfield>freeze_max_age</structfield>), ! are used to set table-specific values for ! <xref linkend="guc-vacuum-freeze-min-age"> and ! <xref linkend="guc-autovacuum-freeze-max-age"> respectively. </para> <para> - If any of the values in <structname>pg_autovacuum</structname> - are set to a negative number, or if a row is not present at all in - <structname>pg_autovacuum</structname> for any particular table, the - corresponding values from <filename>postgresql.conf</filename> are used. - </para> - - <para> - There is not currently any support for making - <structname>pg_autovacuum</structname> entries, except by doing - manual <command>INSERT</>s into the catalog. This feature will be - improved in future releases, and it is likely that the catalog - definition will change. - </para> - - <caution> - <para> - The contents of the <structname>pg_autovacuum</structname> system - catalog are currently not saved in database dumps created by the - tools <application>pg_dump</> and <application>pg_dumpall</>. If - you want to preserve them across a dump/reload cycle, make sure - you dump the catalog manually. - </para> - </caution> - - <para> When multiple workers are running, the cost limit is <quote>balanced</quote> among all the running workers, so that the total impact on the system is the same, regardless of the number --- 606,645 ---- <para> The default thresholds and scale factors are taken from <filename>postgresql.conf</filename>, but it is possible to override them ! on a table-by-table basis; see ! <xref linkend="sql-createtable-storage-parameters" ! endterm="sql-createtable-storage-parameters-title"> for more information. ! If a setting ! has been changed via storage parameters, that value is used; otherwise the ! global settings are used. See <xref linkend="runtime-config-autovacuum"> for more details on the global settings. </para> <para> ! Besides the base threshold values and scale factors, there are six ! more autovacuum parameters that can be set for each table via ! storage parameters. ! The first parameter, <literal>autovacuum_enabled</>, can be set to <literal>false</literal> to instruct the autovacuum daemon to skip that particular table entirely. In this case autovacuum will only touch the table if it must do so to prevent transaction ID wraparound. ! Another two parameters, ! <literal>autovacuum_vacuum_cost_delay</literal> and ! <literal>autovacuum_vacuum_cost_limit</literal>, are used to set ! table-specific values for the ! <xref linkend="runtime-config-resource-vacuum-cost" ! endterm="runtime-config-resource-vacuum-cost-title"> feature. ! <literal>autovacuum_freeze_min_age</literal>, ! <literal>autovacuum_freeze_max_age</literal> and ! <literal>autovacuum_freeze_table_age</literal> are used to set ! values for <xref linkend="guc-vacuum-freeze-min-age">, ! <xref linkend="guc-autovacuum-freeze-max-age"> and ! <xref linkend="guc-vacuum-freeze-table-age"> respectively. </para> <para> When multiple workers are running, the cost limit is <quote>balanced</quote> among all the running workers, so that the total impact on the system is the same, regardless of the number *** doc/src/sgml/ref/alter_index.sgml 14 Nov 2008 10:22:45 -0000 1.14 --- doc/src/sgml/ref/alter_index.sgml 29 Jan 2009 17:23:12 -0000 *************** *** 75,80 **** --- 75,90 ---- </listitem> </varlistentry> + <varlistentry> + <term><replaceable class="PARAMETER">value</replaceable></term> + <listitem> + <para> + The new value for a storage parameter. + This might be a number or a word depending on the parameter. + </para> + </listitem> + </varlistentry> + <varlistentry> <term><literal>RESET ( <replaceable class="PARAMETER">storage_parameter</replaceable> [, ... ] )</literal></term> <listitem> *** doc/src/sgml/ref/alter_table.sgml 13 Dec 2008 19:13:44 -0000 1.102 --- doc/src/sgml/ref/alter_table.sgml 6 Feb 2009 14:07:49 -0000 *************** *** 286,292 **** <listitem> <para> This form changes one or more storage parameters for the table. See ! <xref linkend="SQL-CREATETABLE" endterm="sql-createtable-title"> for details on the available parameters. Note that the table contents will not be modified immediately by this command; depending on the parameter you might need to rewrite the table to get the desired effects. --- 286,293 ---- <listitem> <para> This form changes one or more storage parameters for the table. See ! <xref linkend="SQL-CREATETABLE-storage-parameters" ! endterm="sql-createtable-storage-parameters-title"> for details on the available parameters. Note that the table contents will not be modified immediately by this command; depending on the parameter you might need to rewrite the table to get the desired effects. *** doc/src/sgml/ref/create_table.sgml 2 Feb 2009 19:31:38 -0000 1.112 --- doc/src/sgml/ref/create_table.sgml 6 Feb 2009 14:20:05 -0000 *************** *** 685,703 **** <refsect2 id="SQL-CREATETABLE-storage-parameters"> <title id="SQL-CREATETABLE-storage-parameters-title">Storage Parameters</title> <para> The <literal>WITH</> clause can specify <firstterm>storage parameters</> for tables, and for indexes associated with a <literal>UNIQUE</literal> or <literal>PRIMARY KEY</literal> constraint. Storage parameters for indexes are documented in <xref linkend="SQL-CREATEINDEX" endterm="sql-createindex-title">. The storage parameters currently ! available for tables are: </para> <variablelist> <varlistentry> ! <term><literal>FILLFACTOR</></term> <listitem> <para> The fillfactor for a table is a percentage between 10 and 100. --- 685,713 ---- <refsect2 id="SQL-CREATETABLE-storage-parameters"> <title id="SQL-CREATETABLE-storage-parameters-title">Storage Parameters</title> + <indexterm zone="sql-createtable-storage-parameters"> + <primary>storage parameters</primary> + </indexterm> + <para> The <literal>WITH</> clause can specify <firstterm>storage parameters</> for tables, and for indexes associated with a <literal>UNIQUE</literal> or <literal>PRIMARY KEY</literal> constraint. Storage parameters for indexes are documented in <xref linkend="SQL-CREATEINDEX" endterm="sql-createindex-title">. The storage parameters currently ! available for tables are listed below. For each parameter, there is an ! additional, identically named parameter, prefixed with ! <literal>toast.</literal> which can be used to control the behavior of the ! supplementary storage table, if any; see <xref linkend="storage-toast">. ! Note that the supplementary storage table inherits the ! <literal>autovacuum</literal> values from its parent table, if there are ! no <literal>toast.autovacuum_*</literal> settings set. </para> <variablelist> <varlistentry> ! <term><literal>fillfactor</>, <literal>toast.fillfactor</literal> (<type>integer</>)</term> <listitem> <para> The fillfactor for a table is a percentage between 10 and 100. *************** *** 715,725 **** </varlistentry> <varlistentry> ! <term><literal>TOAST.FILLFACTOR</literal></term> <listitem> <para> ! Same as above, for the supplementary storage table, if any; see ! <xref linkend="storage-toast">. </para> </listitem> </varlistentry> --- 725,842 ---- </varlistentry> <varlistentry> ! <term><literal>autovacuum_enabled</>, <literal>toast.autovacuum_enabled</literal> (<type>boolean</>)</term> ! <listitem> ! <para> ! Enables or disables the autovacuum daemon on a particular table. ! If true, the autovacuum daemon will initiate a <command>VACUUM</> operation ! on a particular table when the number of updated or deleted tuples exceeds ! <literal>autovacuum_vacuum_threshold</> plus ! <literal>autovacuum_vacuum_scale_factor</> times the number of live tuples ! currently estimated to be in the relation. ! Similarly, it will initiate an <command>ANALYZE</> operation when the ! number of inserted, updated or deleted tuples exceeds ! <literal>autovacuum_analyze_threshold</> plus ! <literal>autovacuum_analyze_scale_factor</> times the number of live tuples ! currently estimated to be in the relation. ! If false, this table will not be autovacuumed, except to prevent ! transaction Id wraparound. See <xref linkend="vacuum-for-wraparound"> for ! more about wraparound prevention. ! Observe that this variable inherits its value from the <xref ! linkend="guc-autovacuum"> setting. ! </para> ! </listitem> ! </varlistentry> ! ! <varlistentry> ! <term><literal>autovacuum_vacuum_threshold</>, <literal>toast.autovacuum_vacuum_threshold</literal> (<type>integer</>)</term> ! <listitem> ! <para> ! Minimum number of updated or deleted tuples before initiate a ! <command>VACUUM</> operation on a particular table. ! </para> ! </listitem> ! </varlistentry> ! ! <varlistentry> ! <term><literal>autovacuum_vacuum_scale_factor</>, <literal>toast.autovacuum_vacuum_scale_factor</literal> (<type>float4</>)</term> ! <listitem> ! <para> ! Multiplier for <structfield>reltuples</> to add to ! <literal>autovacuum_vacuum_threshold</>. ! </para> ! </listitem> ! </varlistentry> ! ! <varlistentry> ! <term><literal>autovacuum_analyze_threshold</>, <literal>toast.autovacuum_analyze_threshold</literal> (<type>integer</>)</term> ! <listitem> ! <para> ! Minimum number of inserted, updated, or deleted tuples before initiate an ! <command>ANALYZE</> operation on a particular table. ! </para> ! </listitem> ! </varlistentry> ! ! <varlistentry> ! <term><literal>autovacuum_analyze_scale_factor</>, <literal>toast.autovacuum_analyze_scale_factor</literal> (<type>float4</>)</term> ! <listitem> ! <para> ! Multiplier for <structfield>reltuples</> to add to ! <literal>autovacuum_analyze_threshold</>. ! </para> ! </listitem> ! </varlistentry> ! ! <varlistentry> ! <term><literal>autovacuum_vacuum_cost_delay</>, <literal>toast.autovacuum_vacuum_cost_delay</literal> (<type>integer</>)</term> ! <listitem> ! <para> ! Custom <xref linkend="guc-autovacuum-vacuum-cost-delay"> parameter. ! </para> ! </listitem> ! </varlistentry> ! ! <varlistentry> ! <term><literal>autovacuum_vacuum_cost_limit</>, <literal>toast.autovacuum_vacuum_cost_limit</literal> (<type>integer</>)</term> ! <listitem> ! <para> ! Custom <xref linkend="guc-autovacuum-vacuum-cost-limit"> parameter. ! </para> ! </listitem> ! </varlistentry> ! ! <varlistentry> ! <term><literal>autovacuum_freeze_min_age</>, <literal>toast.autovacuum_freeze_min_age</literal> (<type>integer</>)</term> ! <listitem> ! <para> ! Custom <xref linkend="guc-vacuum-freeze-min-age"> parameter. Note that ! autovacuum will ignore attempts to set a per-table ! <literal>autovacuum_freeze_min_age</> larger than the half system-wide ! <xref linkend="guc-autovacuum-freeze-max-age"> setting. ! </para> ! </listitem> ! </varlistentry> ! ! <varlistentry> ! <term><literal>autovacuum_freeze_max_age</>, <literal>toast.autovacuum_freeze_max_age</literal> (<type>integer</>)</term> ! <listitem> ! <para> ! Custom <xref linkend="guc-autovacuum-freeze-max-age"> parameter. Note that ! autovacuum will ignore attempts to set a per-table ! <literal>autovacuum_freeze_max_age</> larger than the system-wide setting ! (it can only be set smaller). Note that while you can set ! <literal>autovacuum_freeze_max_age</> very small, or even zero, this is ! usually unwise since it will force frequent vacuuming. ! </para> ! </listitem> ! </varlistentry> ! ! <varlistentry> ! <term><literal>autovacuum_freeze_table_age</literal> (<type>integer</type>)</term> <listitem> <para> ! Custom <xref linkend="guc-vacuum-freeze-table-age"> parameter. </para> </listitem> </varlistentry>
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers