Greenplum Database Maintenance and Performance Monitoring Report Scripts
1. Regular database maintenance scripts
2. Performance monitoring using gpperfmon database tables and views
3. Activity monitoring using gp_toolkit schema tables and views
4. Script to generate daily health check status report
Running smart vacuum and analyze in pre-specified maintenance window - Nov 11, 2014 12:16:2 AM
Sachi's greenplum catalog bloat maintenance script - Oct 17, 2014 12:8:24 AM
Sachi's bloat table maintenance script in Greenplum database - Oct 16, 2014 11:37:48 PM
Sachi's greenplum database weekly/daily index maintenance scripts - Oct 16, 2014 2:18:36 PM
Sachi's Greenplum user database maintenance script - Oct 16, 2014 12:23:22 PM
Sachi's daily catalog maintenance scripts - Run vacuum, reindex and analyze on user selected database - Oct 15, 2014 2:47:34 PM
Finding distribution keys of all tables in the greenplum database - Jul 25, 2014 11:59:56 AM