Online Documentation for SQL Manager for PostgreSQL

Vacuum Tables


Vacuum Tables Wizard reclaims storage occupied by deleted tuples (with PostgreSQL routines used).

 

In normal PostgreSQL operation, tuples that are deleted or obsolete due to an update are not physically removed from their table; they remain present until a VACUUM is done. Therefore it is necessary perform this operation periodically, especially on frequently updated tables.

 

To run the wizard, select the Services | iconServices_VacuumTables Vacuum Tables... main menu item, or right-click the database alias in the DB Explorer tree and select the Tasks | iconServices_VacuumTables Vacuum Tables... item from the context menu.

 

menuVacuumTables

 

 

Availability:

Full version (for Windows)

Yes

Lite version (for Windows)

No

Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page.