-
- 管理概述
- 集群性能监控
- 排查系统问题
- 系统目录参考
- 系统表
- 系统视图
- 系统目录定义
- gp_configuration_history
- gp_db_interfaces
- gp_distributed_log
- gp_distributed_xacts
- gp_distribution_policy
- gpexpand.expansion_progress
- gpexpand.status
- gpexpand.status_detail
- gp_fastsequence
- gp_fault_strategy
- gp_global_sequence
- gp_id
- gp_interfaces
- gp_persistent_database_node
- gp_persistent_filespace_node
- gp_persistent_relation_node
- gp_persistent_tablespace_node
- gp
- gp_relation_node
- gp_resqueue_status
- gp_segment_configuration
- gp_transaction_log
- gp_version_at_initdb
- pg
- pg
- pg_amop
- pg_amproc
- pg_appendonly
- pg_attrdef
- pg_attribute_encoding
- pg_attribute
- pg_auth_members
- pg_authid
- pg_available_extension_versions
- pg_available_extensions
- pg_cast
- pg_class
- pg_compression
- pg_constraint
- pg_conversion
- pg_database
- pg_depend
- pg_description
- pg_enum
- pg_extension
- pg_exttable
- pg_filespace_entry
- pg_filespace
- pg_index
- pg_inherits
- pg_language
- pg_largeobject
- pg_listener
- pg_locks
- pg_max_external_files
- pg
- pg_opclass
- pg_operator
- pg_partition_columns
- pg_partition_encoding
- pg_partition_rule
- pg_partition_templates
- pg_partition
- pg_partitions
- pg_pltemplate
- pg_proc
- pg_resourcetype
- pg_resqueue_attributes
- pg_resqueue
- pg_resqueuecapability
- pg_rewrite
- pg
- pg_shdepend
- pg
- pg_stat_activity
- pg_stat_last_operation
- pg_stat_last_shoperation
- pg_stat_operations
- pg_stat_partition_operations
- pg_stat_replication
- pg_stat_resqueues
- pg
- pg
- pg_trigger
- pg_type_encoding
- pg_type
- pg_user_mapping
- pg_window
- gp_toolkit 管理方案
- gpperfmon 数据库
- 使用资源队列进行工作负载管理
-
- 系统概述
- 访问数据仓库
- 使用 Python 访问数据仓库
- 使用 R 语言访问数据仓库
- 定义数据库对象
- 数据的管理
- 导入导出数据
- 查询数据
- SQL 命令参考
- SQL语法概要
- ABORT
- ALTER AGGREGATE
- ALTER CONVERSION
- ALTER DATABASE
- ALTER DOMAIN
- ALTER EXTENSION
- ALTER EXTERNAL TABLE
- ALTER FILESPACE
- ALTER FUNCTION
- ALTER GROUP
- ALTER INDEX
- ALTER LANGUAGE
- ALTER OPERATOR CLASS
- ALTER OPERATOR
- ALTER PROTOCOL
- ALTER RESOURCE QUEUE
- ALTER ROLE
- ALTER SCHEMA
- ALTER SEQUENCE
- ALTER TABLE
- ALTER TABLESPACE
- ALTER TYPE
- ALTER USER
- ANALYZE
- BEGIN
- CHECKPOINT
- CLOSE
- CLUSTER
- COMMENT
- COMMIT
- COPY
- CREATE AGGREGATE
- CREATE CAST
- CREATE CONVERSION
- CREATE DATABASE
- CREATE DOMAIN
- CREATE EXTENSION(new)
- CREATE EXTERNAL TABLE
- CREATE FUNCTION
- CREATE GROUP
- CREATE INDEX
- CREATE LANGUAGE
- CREATE OPERATOR CLASS
- CREATE OPERATOR FAMILY
- CREATE OPERATOR
- CREATE PROTOCOL
- CREATE RESOURCE QUEUE
- CREATE ROLE
- CREATE RULE
- CREATE SCHEMA
- CREATE SEQUENCE
- CREATE TABLE AS
- CREATE TABLE
- CREATE TABLESPACE
- CREATE TYPE
- CREATE USER
- CREATE VIEW
- DEALLOCATE
- DECLARE
- DELETE
- DISCARD
- DO
- DROP AGGREGATE
- DROP CAST
- DROP CONVERSION
- DROP DATABASE
- DROP DOMAIN
- DROP EXTENSION
- DROP EXTERNAL TABLE
- DROP FILESPACE
- DROP FUNCTION
- DROP GROUP
- DROP INDEX
- DROP LANGUAGE
- DROP OPERATOR CLASS
- DROP OPERATOR FAMILY
- DROP OPERATOR
- DROP OWNED
- DROP PROTOCOL
- DROP RESOURCE QUEUE
- DROP ROLE
- DROP RULE
- DROP SCHEMA
- DROP SEQUENCE
- DROP TABLE
- DROP TABLESPACE
- DROP TYPE
- DROP USER
- DROP VIEW
- END
- EXECUTE
- EXPLAIN
- FETCH
- GRANT
- INSERT
- LOAD
- LOCK
- MOVE
- PREPARE
- REASSIGN OWNED
- REINDEX
- RELEASE SAVEPOINT
- RESET
- REVOKE
- ROLLBACK TO SAVEPOINT
- ROLLBACK
- SAVEPOINT
- SELECT INTO
- SELECT
- SET ROLE
- SET SESSION AUTHORIZATION
- SET TRANSACTION
- SET
- SHOW
- START TRANSACTION
- TRUNCATE
- UPDATE
- VACUUM
- VALUES
- 数据类型
- 字符集支持
- 系统配置参数
- 内置函数摘要
- PL/Python 语言扩展
- 用于分析的 MADlib 扩展
- PostGIS 扩展
- PL/Java语言扩展
- 与Oracle语法上的差异
- 使用 Jmeter、pgbouncer 对 hashdata 数据库进行压力测试
- 数据加密