Greenplum database system provides following system level schema. These schema contains no of tables, views and functions. A good understanding of the schema objects contained in these system level schema are very critical for the Greenplum DBA's to manage and maintain good health of the Greenplum database system. To learn more about these schema and how they can help you to find most critical information when you need them, visit www.greenplumdba.com . 1. pg_catalog pg_catalog is the schema that has the system catalog tables, built-in data types, functions, and operators. It is always part of the schema search path, even if it is not explicitly named in the search path. For information on the system catalog tables in the pg_catalog schema. 2. information_schema information_schema consists of a standardized set of views that contain information about the objects in the database. These views are used to get system information from the system catalog tables in a standardized way. 3.pg_toast pg_toast is a system schema where large objects are stored (records that exceed the page size). This schema is used internally by the Greenplum Database system and is not typically accessed by database administrators or users. 4.pg_bitmapindex pg_bitmapindex is the system schema where bitmap index objects are stored (list of values, etc.). This schema is used internally by the Greenplum Database system and is not typically accessed by database administrators or users. 5.pg_aoseg pg_aoseg is the system schema where append-only table objects are stored. This schema is used internally by the Greenplum Database system and is not typically accessed by database administrators or users. 6. gp_toolkit gp_toolkit is an administrative schema that you can use to view and query the system log files and other system metrics. The gp_toolkit schema contains a number of external tables, views and functions that you can access by using SQL commands. gp_toolkit is accessible by all database users. |
|
|