0 like 0 dislike
107 views

Please log in or register to answer this question.

1 Answer

0 like 0 dislike
answered by (4.8k points)  

Greenplum DBA - Useful catalog tables and views

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.

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

Related questions

0 like 0 dislike
1 answer
0 like 0 dislike
0 answers
Welcome to PostgreSQL Database Discussion Forum where you can ask questions and receive answers from other members of the community. Can discuss here Oracle, Postgresql, mariadb , mySQL , AWS , Linux , MSSQL , MongoDB , Greenplum databases related queries ...etc.
...