|
1 |
| -<!-- $PostgreSQL: pgsql/doc/src/sgml/maintenance.sgml,v 1.73 2007/05/03 15:47:48 alvherre Exp $ --> |
| 1 | +<!-- $PostgreSQL: pgsql/doc/src/sgml/maintenance.sgml,v 1.74 2007/05/15 15:52:40 neilc Exp $ --> |
2 | 2 |
|
3 | 3 | <chapter id="maintenance">
|
4 | 4 | <title>Routine Database Maintenance Tasks</title>
|
@@ -485,28 +485,24 @@ HINT: Stop the postmaster and use a standalone backend to VACUUM in "mydb".
|
485 | 485 | multi-process architecture: there is a daemon process, called the
|
486 | 486 | <firstterm>autovacuum launcher</firstterm>, which is in charge of starting
|
487 | 487 | an <firstterm>autovacuum worker</firstterm> process on each database every
|
488 |
| - <xref linkend="guc-autovacuum-naptime"> seconds. |
| 488 | + <xref linkend="guc-autovacuum-naptime"> seconds. On each run, the worker |
| 489 | + process checks each table within that database, and <command>VACUUM</> or |
| 490 | + <command>ANALYZE</> commands are issued as needed. |
489 | 491 | </para>
|
490 | 492 |
|
491 | 493 | <para>
|
492 | 494 | There is a limit of <xref linkend="guc-autovacuum-max-workers"> worker
|
493 | 495 | processes that may be running at any time, so if the <command>VACUUM</>
|
494 | 496 | and <command>ANALYZE</> work to do takes too long to run, the deadline may
|
495 | 497 | be failed to meet for other databases. Also, if a particular database
|
496 |
| - takes long to process, more than one worker may be processing it |
| 498 | + takes a long time to process, more than one worker may be processing it |
497 | 499 | simultaneously. The workers are smart enough to avoid repeating work that
|
498 | 500 | other workers have done, so this is normally not a problem. Note that the
|
499 | 501 | number of running workers does not count towards the <xref
|
500 | 502 | linkend="guc-max-connections"> nor the <xref
|
501 | 503 | linkend="guc-superuser-reserved-connections"> limits.
|
502 | 504 | </para>
|
503 | 505 |
|
504 |
| - <para> |
505 |
| - On each run, the worker process checks each table within that database, and |
506 |
| - <command>VACUUM</command> or <command>ANALYZE</command> commands are |
507 |
| - issued as needed. |
508 |
| - </para> |
509 |
| - |
510 | 506 | <para>
|
511 | 507 | Tables whose <structfield>relfrozenxid</> value is more than
|
512 | 508 | <varname>autovacuum_freeze_max_age</> transactions old are always
|
@@ -591,19 +587,19 @@ analyze threshold = analyze base threshold + analyze scale factor * number of tu
|
591 | 587 | <caution>
|
592 | 588 | <para>
|
593 | 589 | The contents of the <structname>pg_autovacuum</structname> system
|
594 |
| - catalog are currently not saved in database dumps created by |
595 |
| - the tools <command>pg_dump</command> and <command>pg_dumpall</command>. |
596 |
| - If you want to preserve them across a dump/reload cycle, make sure you |
597 |
| - dump the catalog manually. |
| 590 | + catalog are currently not saved in database dumps created by the |
| 591 | + tools <application>pg_dump</> and <application>pg_dumpall</>. If |
| 592 | + you want to preserve them across a dump/reload cycle, make sure |
| 593 | + you dump the catalog manually. |
598 | 594 | </para>
|
599 | 595 | </caution>
|
600 | 596 |
|
601 | 597 | <para>
|
602 |
| - When multiple workers are running, the cost limit is "balanced" among all |
603 |
| - the running workers, so that the total impact on the system is the same, |
604 |
| - regardless of the number of workers actually running. |
| 598 | + When multiple workers are running, the cost limit is |
| 599 | + <quote>balanced</quote> among all the running workers, so that the |
| 600 | + total impact on the system is the same, regardless of the number |
| 601 | + of workers actually running. |
605 | 602 | </para>
|
606 |
| - |
607 | 603 | </sect2>
|
608 | 604 | </sect1>
|
609 | 605 |
|
|
0 commit comments