Database Reference
In-Depth Information
Database VACUUM
The
VACUUM
procedure is responsible for cleaning this set of useless lines in your data-
base, thus ensuring increased performance.
Usually, the default setting of Heroku Postgres automates this procedure, but eventually
you may need to perform this action manually.
The
VACUUM
command searches for useless lines in your database and removes them
physically; this decreases the size of your database accordingly.
VACUUM
also organizes the
records that were not deleted and, so it's guaranteed that there won't be any gaps between
records.
