Vacuum the Whole Database in Postgres

Postgres comes with a functionality called vacuum. Vacuum is intended to cleanup dead tuples or rows.
This is how you cleanup the entire DB in PostgreSQL


/usr/pg9/bin/vacuumdb --full --port=5433 --username=YOUR_USERNAME --password DB_NAME

Leave a Reply

Your email address will not be published. Required fields are marked *


five × = 35