Clean Database
Clean Database
(
) performs a database vacuum operation.
In PostgreSQL, records that are deleted or obsolete are not physically removed from
tables, but rather are marked as inactive. After a large number of delete or insert
actions, the database can become less responsive. The Vacuum operation physically
removes deleted and obsolete records, reclaiming storage space and returning the
tables to optimal performance.
The Database Vacuum Wizard
Selecting Clean Database opens a wizard page with four selections. Review and complete these items and then click Finish to start the operation.
-
Full. This option performs a
thorough vacuum of the entire database. Although this can take some time, a full
vacuum is recommended periodically, at least after every 500 million
transactions.
-
Freeze. The vacuum utility
attempts to operate with minimal impact on database use. The Freeze option
performs a more aggressive freeze of tuples during vacuum.
-
Verbose. This option causes
detailed information about the vacuum operation to be provided upon completion
of the task. Enabling this option is recommended, as this feedback can be
useful.
-
Analyze. Analyze collects
statistics about the database tables that are used by the query planner to
increase the efficiency of PostgreSQL. Enabling this option results in an
analyze operation being performed after the vacuum. This is recommended.