Search this site
GreenplumDBA Home
GreenplumDBA Members Club
GreenplumDBA LinkedIn Group
DBARef.com
Liability Disclaimer
Pivotal GPDB Documents
DBA Scripts Download - Members Only
Getting Started with Greenplum Database
Installing Greenplum Database
Configuring Greenplum Database
Securing your database
Allowing Connections to Greenplum Database
Securing Greenplum Database
MPP Data Models
Greenplum Database Quick Facts
Gpfdist
Set Database Environment
Set Environment variables and Path
Create Database
Create Roles (users and group roles)
Create Resource Queues
Granting Privilege and Role
Schema Development
Schema
Tables/
External Tables
Views
Functions
PSQL
Migrating to Greenplum
Oracle to Greenplum
PostgreSQL to Greenplum
Monitoring and Maintenance
gp_toolkit Schema
pg_catalog schema
Reporting
Sachi's AWR Report for Greenplum Database
Schema Size
Greenplum database performance tuning
Best practice
Tuning the environment
Tuning configuration parameters
Tuning SQL
Tuning data models
pg_catalog tables
Catalog Name
Purpose
pg_aggregate
aggregate functions
pg_am
index access methods
pg_amop
access method operators
pg_amproc
access method support procedures
pg_attrdef
column default values
pg_attribute
table columns (
"attributes"
)
pg_authid
authorization identifiers (roles)
pg_auth_members
authorization identifier membership relationships
pg_autovacuum
per-relation autovacuum configuration parameters
pg_cast
casts (data type conversions)
pg_class
tables, indexes, sequences, views (
"relations"
)
pg_constraint
check constraints, unique constraints, primary key constraints, foreign key constraints
pg_conversion
encoding conversion information
pg_database
databases within this database cluster
pg_depend
dependencies between database objects
pg_description
descriptions or comments on database objects
pg_index
additional index information
pg_inherits
table inheritance hierarchy
pg_language
languages for writing functions
pg_largeobject
large objects
pg_listener
asynchronous notification support
pg_namespace
schemas
pg_opclass
index access method operator classes
pg_operator
operators
pg_pltemplate
template data for procedural languages
pg_proc
functions and procedures
pg_rewrite
query rewrite rules
pg_shdepend
dependencies on shared objects
pg_shdescription
comments on shared objects
pg_statistic
planner statistics
pg_tablespace
tablespaces within this database cluster
pg_trigger
triggers
pg_type
data types
Comments