Greenplum Database

Quick facts about Greenplum Database
Greenplum Database is an array of individual databases based upon PostgreSQL 8.2 working together to present a single database image. 
Greenplum Database stores and processes large amounts of data by distributing the data and processing workload across several servers or hosts
The master is the entry point to the Greenplum Database system.
It is the database instance to which clients connect and submit SQL statements.
The master coordinates its work with the other database instances in the system, called segments.
It is the segments where data is stored and the majority of query processing takes place.
Greenplum Database end-users interact with Greenplum Database (through the master).
End-users connect to the Greenplum database using client programs such as psql or APIs such as JDBC or ODBC.
The master is where the global system catalog resides.
The global system catalog is the set of system tables that contain metadata about the Greenplum Database system itself.
The master does not contain any user data.
Data resides only on the segments.
The master authenticates client connections
The master processes incoming SQL commands
Master distributes workload among segments, coordinates the results returned by each segment
It is the master which presents the final results to the client program.
When a user connects to the database and issues a query, processes are created on each segment to handle the work of that query.
User-defined tables and their indexes are distributed across the available segments in a Greenplum Database system
Each segment contains a distinct portion of data.
The database server processes that serve segment data run under the corresponding segment instances.

Learn more about

Greenplum Master Click here
Greenplum Segments Click here
Greenplum Interconnect Click here
Starting and Stopping Greenplum Click here
Greenplum database log files
Greenplum database system catalog
Configuring Greenplum System
Greenplum Parallel Data Loading
Audit Logging
Monitoring and Performance Tuning
DCA Storage and omreport
SNMP Alerts and SNMP Traps

Sachi's Oracle to Greenplum Data Migration scripts
Greenplum DCA
Checking for Tables that Need Routine Maintenance
Greenplum DIA
Collecting and monitoring table statistics in Greenplum
Gptransfer utility in Greenplum
Data Domain
Sachi's Greenplum database maintenance and monitoring scripts
GemFire XD
Helpful UNIX Commands for Greenplum DBA's
Reading EXPLAIN and EXPLAIN ANALYZE Output in Greenplum
Helpful SQL queries for Greenplum DBA's
Helpful commands and utilities for Greenplum DBA's
Greenplum Database Management Utilities
Greenplum Database Client Utility
Greenplum Database
Release Notes
Greenplum Database File Structure
Quick Reference
Tools and Utilities
Useful Links
Pivotal Support 
Pivotal Docs 
Debugging SQL Query Performance Issues
Greenplum Chorus
Installing the greenplum database
Installation Management Utilities
Common Terminology in Greenplum Database
Greenplum Database Maximum Limits
SQL Command Reference
Management Utility Reference
Client Utility Reference
Environment Variables
Expanding a Greenplum System
Routine System Maintenance Tasks
External Tables for data loading and unloading

Oracle Compatibility Functions
DCA to DCA Data Transfer
Greenplum Database Backup
Greenplum Database Restore
Single Table backup
Single table Restore
Collecting Stats in Greenplum
Explain Plan in Greenplum
Display Greenplum Database Configuration Parameters
Modify Greenplum Database Configuration Parameters
Display Size of Table in Greenplum
Display Size of Schema in Greenplum
Display Database Size in Greenplum
Display Distribution Key in Greenplum
Display distribution of rows in Greenplum segments
gp_toolkit Schema
pg_catalog schema
Greenplum Database Quick Facts
Greenplum eBooks
Greenplum Database - Common Terminology
Greenplum DCA performance monitoring SQL
Performance Monitoring in Greenplum
ConnectEMC Event Alerts
Greenplum database tutorial
GPDB Monitoring and Maintenance
Disk Spill
GP Bloat
Greenplum DBA routine tasks
Monitoring Skew
Viewing the last operation performed
Greenplum database catalog monitoring and repair
What's new in Greenplum database 4.3?
Greenplum Database 4.3 Supported Platforms
Deprecated feature in Greenplum database 4.3
Changed Features in Greenplum Database 3.0
Greenplum Database 4.3 Upgrade Checklist
Upgrading Greenplum Database to 4.3
Troubleshooting a Failed Upgrade
Greenplum Database System Catalog
Tables and Views
Greenplum Database Supported
Data Types
Greenplum Database Supported
Character Set
Investigating Error Messages in Greenplum
Gathering Information for Greenplum Support
Known Issues in Greenplum Database
Resolved Issues in Greenplum Database 4.3
Greenplum Configuration Parameters
Greenplum Oracle Compatibility
Checking database activity
Greenplum Workload Management
Greenplum Command Center
Transforming XML Data
Partitioning in Greenplum
Troubleshooting DCA issues

Backup and Restore
Greenplum Command line utilities
Greenplum Command Center
Greenplum Chorus
Data Domain