To run a database vacuum on one database table, follow these steps:

Step

Action (Linux)

1

Log into the Database server as a user with administrator privileges.

2

Log into the database as the pgdba user using the su – pgdba command.

3

Navigate to the psql prompt.

Type psql voyencedb voyence to navigate to the psql prompt, and press Enter.

4

Run the database vacuum.

Type vacuum <table_name>;, where <table_name> is the name of the table to be vacuumed, and press Enter.

Note:

The database vacuum may take several minutes/hours depending on the size of your database.

5

Repeat step 4 for each table you want to cleanup.