Greenplum Database, like any database software, requires that certain tasks be performed regularly to achieve optimum performance. The tasks discussed here are required, but they are repetitive in nature and can easily be automated using standard Unix tools such as cron scripts. But it is the database administrator’s responsibility to set up appropriate scripts, and to check that they execute successfully.
1. Routine Vacuum and Analyze
2. Routine Reindexing
3. Managing Greenplum Database Log Files