Running  smart vacuum and analyze in pre-specified maintenance window

Post date: Nov 11, 2014 12:16:2 AM

There is a  compelling requirement for all Greenplum DBA to run the maintenance tasks in a pre-specified window. Depending on the data volume, No of columns in tables and other factors, your daily maintenance job may run longer than maintenance window. One dirty way is to kill the job that is running beyond the maintenance window but this may leads your database in a inconsistent state and may raise other issues.

Here is the script that will do vacuum and analyze on tables in a prespecified time limit. The script will automatically exit after Runtime Exceeded Project maintenance Window.

[gpadmin@sachi scripts]$ ./projectdb_maint_daily.sh

Script is running.Please wait.It may take few minutes...

Runtime Exceeded Project maintenance Window. Now exiting!!!!!!!!

Script completed. Script log is available at /home/gpadmin/maintenance/logs

Filename:/home/gpadmin/maintenance/logs/projectdb_maint_daily_log_2014-11-10_19:03.log

[gpadmin@sachi scripts]$ 

Script will run next day from the table where it left on previous day.