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
Read more about Vacuum, Vacuum full, fastest way to reclaim the space and other maintenance scripts, visit www.greenplumdba.com (available to DBARef.com registered user only. Click here to become DBARef.com registered user.