Running a partial database vacuum

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.