Why need the database maintenance?
PostgreSQL, like any database requires regular maintenance tasks.
You can prevent from slow response or expanding database size by executing the maintenance tasks.
Execution Examples
To maintain the database, use PostgreSQL's maintenance commands.
Please refer the execution example below. Use su command to switch to user "postgres".
Example 1
% vacuumdb -v -z -d dnpwmldb -U postgres
This command recovers or reuses disk space occupied by deleted data.
* When you execute the vacuumdb command, it may cause poor performance for Denbun.
Example 2
% vacuumdb -f -v -z -d dnpwmldb -U postgres
% reindexdb -d dnpwmldb -U postgres
This command recovers or reuses disk space occupied by deleted data.
* It compacts the data and saves it again. It makes more disk space.
* It recreates the index to delete the unnecessary indexes.
* All the users cannot use Denbun when you perform vacuumdb (with -f option), or reindexdb command.
* The process time varies depending on the data volume.
Please try [Example 2] if you feel poor performance for Denbun.
We recommend that you perform [Example 1] weekly and perform [Example 2] monthly basis.
The process speed varies depending on maintenance frequency.
Back to Menu