|
1 | 1 | <!-- |
2 | | -$PostgreSQL: pgsql/doc/src/sgml/maintenance.sgml,v 1.46 2005/09/13 01:51:18 alvherre Exp $ |
| 2 | +$PostgreSQL: pgsql/doc/src/sgml/maintenance.sgml,v 1.47 2005/09/16 03:12:32 alvherre Exp $ |
3 | 3 | --> |
4 | 4 |
|
5 | 5 | <chapter id="maintenance"> |
@@ -542,10 +542,20 @@ vacuum threshold = vacuum base threshold + vacuum scale factor * number of tuple |
542 | 542 | values, the <varname>vacuum_cost_limit</varname> and |
543 | 543 | <varname>vacuum_cost_delay</varname> values will be used instead. |
544 | 544 | The other parameter, <structname>pg_autovacuum</>.<structfield>enabled</>, |
545 | | -can be used to instruct the autovacuum daemon to skip any particular table |
546 | | -by setting it to <literal>false</literal>. |
| 545 | +can be used to instruct the autovacuum daemon to skip any particular table |
| 546 | +by setting it to <literal>false</literal>. |
547 | 547 | </para> |
548 | 548 |
|
| 549 | + <note> |
| 550 | + <para> |
| 551 | + The contents of the <structname>pg_autovacuum</structname> system |
| 552 | + catalog are currently not saved in database dumps created by |
| 553 | + the tools <command>pg_dump</command> and <command>pg_dumpall</command>. |
| 554 | + If you need to preserve them across a dump/reload cycle, make sure you |
| 555 | + dump the catalog manually. |
| 556 | + </para> |
| 557 | + </note> |
| 558 | + |
549 | 559 | </sect2> |
550 | 560 | </sect1> |
551 | 561 |
|
|