Server Maintenance is an xTuple ERP batch job that performs a complete PostgreSQL VACUUM FULL ANALYZE and REINDEX on the xTuple ERP database. While PostgreSQL is by default configured to run the AUTOVACUUM daemon, it is prudent to perform a complete vacuum on a periodic basis. This interval should, in general, be not more than once a day and no less than once a week. It is best to schedule this to run at an off-peak time and as a recurring job, as described in Section 6, “Scheduling Recurring Jobs”.
Note
In order for the REINDEX to be performed, the user that is used to log on with the Batch Manager client must be a superuser on the PostgreSQL database.
To schedule Server Maintenance and submit the job to the Batch Manager, follow these steps:
Follow this path:
In the "Response Email" field, the name of the user who submitted the job will appear
We will leave the schedule date ASAP, as shown in the following screen:
If you return back to the main Batch Manager screen to monitor the status of this job, you will see an entry for it with the action "ServerMaintenance". Keep in mind that you can use the steps described in Section 6, “Scheduling Recurring Jobs” to reschedule the Server Maintenance job to run daily, weekly, or monthly.