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