What is the purpose of the PostgreSQL vacuum command?

Vaibhav Kothia May 26, 2023 0 Comments

The PostgreSQL vacuum command is used to reclaim storage space and prevent transaction id wraparound. It is an important maintenance command that helps maintain the performance and integrity of the database.

Vacuuming is done to remove old data that is no longer needed. This can be done manually with the VACUUM command.

Example:

To vacuum the table ‘users’ and reclaim any unused space:

VACUUM users;