Managing Performance

The topics in this section cover Greenplum Database performance management, including how to monitor performance and how to configure workloads to prioritize resource utilization.

  • Defining Database Performance
    Managing system performance includes measuring performance, identifying the causes of performance problems, and applying the tools and techniques available to you to remedy the problems.
  • Common Causes of Performance Issues
    This section explains the troubleshooting processes for common performance issues and potential solutions to these issues.
  • Workload Management with Resource Queues
    Use Greenplum workload management to prioritize and allocate resources to queries according to business requirements and to prevent queries from starting when resources are unavailable.
  • Investigating a Performance Problem
    This section provides guidelines for identifying and troubleshooting performance problems in a Greenplum Database system.
Parent topic: Greenplum Database Administrator Guide