Clean Database

Clean Database (Vacuum icon) 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.