The gadget spec URL could not be found
Scope: 1. Restrict vacuum and analyze in prespecified maintenance window 2. Run vacuum and analyze separately not from a single command VACUUM ANALYZE' 3. vacuum and analyze table on a predefined threshold time 4. Smart analyze ( analyze only those columns necessary). Configurable and prepoulated 5. vacuum and analyze largest table first 6. Run multiple session --coming soon!!!!!!!!!!!!!! Usage The gadget spec URL could not be found gpadmin@sachi scripts]$ ./projectdb_maint_daily_sachi.sh The gadget spec URL could not be found Sample log VACUUM ANALYZE "sachi"."sales_1_prt_2_2_prt_7_3_prt_asia"(id);; ANALYZE VACUUM "sachi"."sales_1_prt_2_2_prt_7_3_prt_europe"; VACUUM ANALYZE "sachi"."sales_1_prt_2_2_prt_7_3_prt_europe"(id);; ANALYZE VACUUM "sachi"."sales_1_prt_2_2_prt_7_3_prt_other_regions"; VACUUM ANALYZE "sachi"."sales_1_prt_2_2_prt_7_3_prt_other_regions"(id);; ANALYZE VACUUM "sachi"."sales_1_prt_2_2_prt_7_3_prt_usa"; VACUUM ANALYZE "sachi"."sales_1_prt_2_2_prt_7_3_prt_usa"(id);; ANALYZE VACUUM "sachi"."sales_1_prt_2_2_prt_7"; VACUUM ANALYZE "sachi"."sales_1_prt_2_2_prt_7"(id);; ANALYZE 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_ouput_2014-11-11_09:45.log [gpadmin@sachi scripts]$ ./projectdb_maint_daily_new.sh | The gadget spec URL could not be found |
The gadget spec URL could not be found