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.