Internet Express for Tru64 UNIX Version 6.8 Administration Guide (14233)

Using the Administration utility, you can set up a crontab entry that runs a vacuum on your
entire database at a specified time of day at daily or weekly intervals. The PostgreSQL server
must be running for the vacuum to be performed.
Although the vacuum can run in parallel with normal database operations (that is, select, insert,
update, and delete), HP recommends that you schedule your database to be vacuumed during
a low-usage period.
To schedule the database vacuum, follow these steps:
1. From the Manage Components menu, choose PostgreSQL Database Management System.
2. From the PostgreSQL Database Management System form, choose Setup Vacuum Crontab.
The Setup Vacuum Crontab form is displayed, allowing you to specify and submit the
database vacuum options (Figure 17-4).
Figure 17-4 Setup Vacuum Crontab Form
3. On the Setup Vacuum Crontab form, provide the following settings:
• Select the desired frequency for the database vacuum: daily or weekly. If you select
weekly, also select the day of the week that you would want to run the vacuum.
• Select time of day using 24-hour clock format. This is the time that the vacuum will run.
• If your system is part of a cluster, you must also select the cluster member from which
to run the vacuum.
4. If there was no previous crontabentry, click on Create New to add the entry. If there was
an existing entry, click on Submit to update the crontab entry with the new values. A status
message is displayed when the operation has completed.
5. To delete a crontab entry so that the database vacuum will no longer run, click on Delete.
A status message is displayed when the operation has completed, indicating that the current
entry has been removed.
17.5 Setting up a Crontab Entry for Vacuuming Databases 259