Greenplum Database Best Practices
- Best Practices Summary
A summary of best practices for Greenplum Database.
Requirements and best practices for system administrators who are configuring Greenplum Database cluster hosts.- Schema Design
Best practices for designing Greenplum Database schemas.
Avoid memory errors and manage Greenplum Database resources.- System Monitoring and Maintenance
Best practices for regular maintenance that will ensure Greenplum Database high availability and optimal performance.
Description of the different ways to add data to Greenplum Database.- Security
Best practices to ensure the highest level of system security.
Best practices for implementing encryption and managing keys.- Tuning SQL Queries
The Greenplum Database cost-based optimizer evaluates many strategies for executing a query and chooses the least costly method.