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.
  • 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



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
  • Backup and Restore
  • Greenplum Command line utilities
  • Greenplum Command Center
  • Greenplum Chorus
  • Data Domain
  • Oracle Compatibility Functions
  • DCA to DCA Data Transfer
  • GPFDist
  • GPLoad
  • Greenplum Database Backup
Comments