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
    Both external and foreign tables provide access to data stored in data sources outside of Greenplum Database as if the data were stored in regular database tables. You can read data from and write data to external and foreign 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.