A common question I get is what maintenance activity is needed in HAWQ and Greenplum database. There are lots of ways to handle this and a lot of customers do it as part of their ETL processing. I put together a script that is pretty generic and should be very useful for most implementations.
The script is available on Github in a new project I created for scripts. As I come up with more scripts for various activities, I will put it in this Github repository.
maintain.sh
Note: Run this script on a regular basis such as weekly or monthly.
Enjoy!