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 Compression 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 GPFDist GPLoad 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 PSQL Greenplum Database - Common Terminology Greenplum DCA performance monitoring SQL Performance Monitoring in Greenplum ConnectEMC Event Alerts Greenplum database tutorial GPDB Monitoring and Maintenance MONITORING DISK SPACE in Greenplum 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 |
|
|