Greenplum Database Administrator Guide

Information about configuring, managing and monitoring Greenplum Database installations, and administering, monitoring, and working with databases. The guide also contains information about Greenplum Database architecture and concepts such as parallel processing.

  • Greenplum Database Concepts
    This section provides an overview of Greenplum Database components and features such as high availability, parallel data loading features, and management utilities.
  • Managing a Greenplum System
    This section describes basic system administration tasks performed by a Greenplum Database system administrator.
  • Managing Greenplum Database Access
    Securing Greenplum Database includes protecting access to the database through network configuration, database user authentication, and encryption.
  • Defining Database Objects
    This section covers data definition language (DDL) in Greenplum Database and how to create and manage database objects.
  • Distribution and Skew
    Greenplum Database relies on even distribution of data across segments.
  • Inserting, Updating, and Deleting Data
    This section provides information about manipulating data and concurrent access in Greenplum Database.
  • Querying Data
    This topic provides information about using SQL in Greenplum databases.
  • Working with External Data
    External tables provide access to data stored in data sources outside of Greenplum Database as if the data were stored in regular database tables. Data can be read from or written to external tables.
  • Loading and Unloading Data
    The topics in this section describe methods for loading and writing data into and out of a Greenplum Database, and how to format data files.
  • 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.
check-circle-line exclamation-circle-line close-line
Scroll to top icon