bash-3.00# /PostgreSQL/bin/vacuumdb -p 5432 -U sa -z -d inventory_db
“In normal PostgreSQL operation, tuples that are deleted or obsolete by an update are not physically removed from their table; they remain present until a VACUUM is done. Therefore, it is necessary to do VACUUM periodically, especially on frequently updated tables.
vacuumdb is a utility for cleaning a PostgreSQL database. vacuumdb will also generate internal statistics used by the PostgreSQL query optimizer.” – From http://www.cyberciti.biz/tips/postgresql-get-back-storage-occupied-by-deleted-tuples-or-records.html
