Greenplum Database Documentation
Back to Greenplum Database
Wiki
Doc Index
Greenplum数据库® 6.0文档
参考指南
SQL Command Reference
SQL Syntax Summary
ABORT
ALTER AGGREGATE
ALTER COLLATION
ALTER CONVERSION
ALTER DATABASE
ALTER DEFAULT PRIVILEGES
ALTER DOMAIN
ALTER EXTENSION
ALTER EXTERNAL TABLE
ALTER FOREIGN DATA WRAPPER
ALTER FOREIGN TABLE
ALTER FUNCTION
ALTER GROUP
ALTER INDEX
ALTER LANGUAGE
ALTER OPERATOR
ALTER OPERATOR CLASS
ALTER OPERATOR FAMILY
ALTER PROTOCOL
ALTER RESOURCE GROUP
ALTER RESOURCE QUEUE
ALTER ROLE
ALTER SCHEMA
ALTER SEQUENCE
ALTER SERVER
ALTER TABLE
ALTER TABLESPACE
ALTER TEXT SEARCH CONFIGURATION
ALTER TEXT SEARCH DICTIONARY
ALTER TEXT SEARCH PARSER
ALTER TEXT SEARCH TEMPLATE
ALTER TYPE
ALTER USER
ALTER USER MAPPING
ALTER VIEW
ANALYZE
BEGIN
CHECKPOINT
CLOSE
CLUSTER
COMMENT
COMMIT
COPY
CREATE AGGREGATE
CREATE CAST
CREATE COLLATION
CREATE CONVERSION
CREATE DATABASE
CREATE DOMAIN
CREATE EXTENSION
CREATE EXTERNAL TABLE
CREATE FOREIGN DATA WRAPPER
CREATE FOREIGN TABLE
CREATE FUNCTION
CREATE GROUP
CREATE INDEX
CREATE LANGUAGE
CREATE OPERATOR
CREATE OPERATOR CLASS
CREATE OPERATOR FAMILY
CREATE PROTOCOL
CREATE RESOURCE GROUP
CREATE RESOURCE QUEUE
CREATE ROLE
CREATE RULE
CREATE SCHEMA
CREATE SEQUENCE
CREATE SERVER
CREATE TABLE
CREATE TABLE AS
CREATE TABLESPACE
CREATE TEXT SEARCH CONFIGURATION
CREATE TEXT SEARCH DICTIONARY
CREATE TEXT SEARCH PARSER
CREATE TEXT SEARCH TEMPLATE
CREATE TYPE
CREATE USER
CREATE USER MAPPING
CREATE VIEW
DEALLOCATE
DECLARE
DELETE
DISCARD
DO
DROP AGGREGATE
DROP CAST
DROP COLLATION
DROP CONVERSION
DROP DATABASE
DROP DOMAIN
DROP EXTENSION
DROP EXTERNAL TABLE
DROP FOREIGN DATA WRAPPER
DROP FOREIGN TABLE
DROP FUNCTION
DROP GROUP
DROP INDEX
DROP LANGUAGE
DROP OPERATOR
DROP OPERATOR CLASS
DROP OPERATOR FAMILY
DROP OWNED
DROP PROTOCOL
DROP RESOURCE GROUP
DROP RESOURCE QUEUE
DROP ROLE
DROP RULE
DROP SCHEMA
DROP SEQUENCE
DROP SERVER
DROP TABLE
DROP TABLESPACE
DROP TEXT SEARCH CONFIGURATION
DROP TEXT SEARCH DICTIONARY
DROP TEXT SEARCH PARSER
DROP TEXT SEARCH TEMPLATE
DROP TYPE
DROP USER
DROP USER MAPPING
DROP VIEW
END
EXECUTE
EXPLAIN
FETCH
GRANT
INSERT
LOAD
LOCK
MOVE
PREPARE
REASSIGN OWNED
REINDEX
RELEASE SAVEPOINT
RESET
REVOKE
ROLLBACK
ROLLBACK TO SAVEPOINT
SAVEPOINT
SELECT
SELECT INTO
SET
SET CONSTRAINTS
SET ROLE
SET SESSION AUTHORIZATION
SET TRANSACTION
SHOW
START TRANSACTION
TRUNCATE
UPDATE
VACUUM
VALUES
SQL 2008可选特性兼容性
Greenplum环境变量
保留标识符和SQL关键字
系统目录参考
系统表
系统视图
系统目录定义
foreign_data_wrapper_options
foreign_data_wrappers
foreign_server_options
foreign_servers
foreign_table_options
foreign_tables
gp_configuration_history
gp_distributed_log
gp_distributed_xacts
gp_distribution_policy
gpexpand.expansion_progress
gpexpand.status
gpexpand.status_detail
gp_fastsequence
gp_id
gp_pgdatabase
gp_resgroup_config
gp_resgroup_status
gp_resgroup_status_per_host
gp_resgroup_status_per_segment
gp_resqueue_status
gp_stat_replication
gp_segment_configuration
gp_transaction_log
gp_version_at_initdb
pg_aggregate
pg_am
pg_amop
pg_amproc
pg_appendonly
pg_attrdef
pg_attribute
pg_attribute_encoding
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_db_role_setting
pg_depend
pg_description
pg_enum
pg_extension
pg_exttable
pg_foreign_data_wrapper
pg_foreign_server
pg_foreign_table
pg_index
pg_inherits
pg_language
pg_largeobject
pg_listener
pg_locks
pg_max_external_files
pg_namespace
pg_opclass
pg_operator
pg_opfamily
pg_partition
pg_partition_columns
pg_partition_encoding
pg_partition_rule
pg_partition_templates
pg_partitions
pg_pltemplate
pg_proc
pg_resgroup
pg_resgroupcapability
pg_resourcetype
pg_resqueue
pg_resqueue_attributes
pg_resqueuecapability
pg_rewrite
pg_roles
pg_shdepend
pg_shdescription
pg_stat_activity
pg_stat_last_operation
pg_stat_last_shoperation
pg_stat_operations
pg_stat_partition_operations
pg_stat_replication
pg_statistic
pg_stat_resqueues
pg_tablespace
pg_trigger
pg_type
pg_type_encoding
pg_user_mapping
pg_user_mappings
user_mapping_options
user_mappings
gp_toolkit管理模式
检查需要例行维护的表
检查锁
检查追加优化表
查看Greenplum数据库服务器日志文件
检查服务器配置文件
检查失败的segments
检查资源组活动和状态
检查资源队列活动和状态
检查查询磁盘溢出空间使用情况
查看用户和组(角色)
检查数据库对象大小和磁盘空间
检查数据分布不均
gpperfmon 数据库
database_* 表
diskspace_* 表
interface_stats_* 表
log_alert_* 表
queries_* 表
segment_* 表
socket_stats_* 表
system_* 表
dynamic_memory_info 视图
memory_info 视图
Greenplum 数据库数据类型
日期/时间类型
伪类型
全文搜索类型
范围类型
字符集支持
服务器配置参数
参数类型和值
设置参数
参数类别
连接和验证参数
系统资源消耗参数
GPORCA参数
查询调优参数
错误报告和日志参数
系统监控参数
运行时统计信息收集参数
自动统计收集参数
客户端连接默认参数
锁管理参数
资源管理参数(资源队列)
资源管理参数(资源组)
外部表参数
数据库表参数
历史版本兼容性参数
Greenplum数据库阵列配置参数
master和segment的Greenplum镜像参数
Greenplum数据库扩展参数
配置参数
application_name
array_nulls
authentication_timeout
backslash_quote
block_size
bonjour_name
check_function_bodies
client_encoding
client_min_messages
cpu_index_tuple_cost
cpu_operator_cost
cpu_tuple_cost
cursor_tuple_fraction
data_checksums
DateStyle
db_user_namespace
deadlock_timeout
debug_assertions
debug_pretty_print
debug_print_parse
debug_print_plan
debug_print_prelim_plan
debug_print_rewritten
debug_print_slice_table
default_statistics_target
default_tablespace
default_text_search_config
default_transaction_deferrable
default_transaction_isolation
default_transaction_read_only
dynamic_library_path
effective_cache_size
enable_bitmapscan
enable_groupagg
enable_hashagg
enable_hashjoin
enable_indexscan
enable_mergejoin
enable_nestloop
enable_seqscan
enable_sort
enable_tidscan
escape_string_warning
explain_pretty_print
extra_float_digits
from_collapse_limit
gp_adjust_selectivity_for_outerjoins
gp_appendonly_compaction
gp_appendonly_compaction_threshold
gp_autostats_mode
gp_autostats_mode_in_functions
gp_autostats_on_change_threshold
gp_cached_segworkers_threshold
gp_command_count
gp_connection_send_timeout
gp_content
gp_create_table_random_default_distribution
gp_dbid
gp_debug_linger
gp_default_storage_options
gp_dynamic_partition_pruning
gp_enable_adaptive_nestloop
gp_enable_agg_distinct
gp_enable_agg_distinct_pruning
gp_enable_direct_dispatch
gp_enable_exchange_default_partition
gp_enable_fast_sri
gp_enable_gpperfmon
gp_enable_groupext_distinct_gather
gp_enable_groupext_distinct_pruning
gp_enable_multiphase_agg
gp_enable_predicate_propagation
gp_enable_preunique
gp_enable_query_metrics
gp_enable_relsize_collection
gp_enable_segment_copy_checking
gp_enable_sort_distinct
gp_enable_sort_limit
gp_external_enable_exec
gp_external_max_segs
gp_external_enable_filter_pushdown
gp_fts_probe_interval
gp_fts_probe_retries
gp_fts_probe_threadcount
gp_fts_probe_timeout
gp_global_deadlock_detector_period
gp_gpperfmon_send_interval
gpperfmon_log_alert_level
gp_hashjoin_tuples_per_bucket
gp_ignore_error_table (不推荐使用)
gp_initial_bad_row_limit
gp_instrument_shmem_size
gp_interconnect_debug_retry_interval
gp_interconnect_fc_method
gp_interconnect_hash_multiplier
gp_interconnect_queue_depth
gp_interconnect_setup_timeout
gp_interconnect_snd_queue_depth
gp_interconnect_type
gp_log_format
gp_log_fts
gp_log_gang
gp_log_interconnect
gp_max_local_distributed_cache
gp_max_packet_size
gp_max_plan_size
gp_max_slices
memory_spill_ratio
gp_motion_cost_per_row
gp_recursive_cte
gp_reject_percent_threshold
gp_reraise_signal
gp_resqueue_memory_policy
gp_resqueue_priority
gp_resqueue_priority_cpucores_per_segment
gp_resqueue_priority_sweeper_interval
gp_resgroup_memory_policy
gp_resource_group_bypass
gp_resource_group_cpu_limit
gp_resource_group_memory_limit
gp_resource_manager
gp_role
gp_safefswritesize
gp_segment_connect_timeout
gp_segments_for_planner
gp_server_version
gp_server_version_num
gp_session_id
gp_set_proc_affinity
gp_set_read_only
gp_statistics_pullup_from_child_partition
gp_statistics_use_fkeys
gp_use_legacy_hashops
gp_vmem_idle_resource_timeout
gp_vmem_protect_limit
gp_vmem_protect_segworker_cache_limit
gp_workfile_compression
gp_workfile_limit_files_per_query
gp_workfile_limit_per_query
gp_workfile_limit_per_segment
gpperfmon_port
ignore_checksum_failure
integer_datetimes
IntervalStyle
join_collapse_limit
keep_wal_segments
krb_caseins_users
krb_server_keyfile
lc_collate
lc_ctype
lc_messages
lc_monetary
lc_numeric
lc_time
listen_addresses
local_preload_libraries
lock_timeout
log_autostats
log_connections
log_disconnections
log_dispatch_stats
log_duration
log_error_verbosity
log_executor_stats
log_hostname
log_min_duration_statement
log_min_error_statement
log_min_messages
log_parser_stats
log_planner_stats
log_rotation_age
log_rotation_size
log_statement
log_statement_stats
log_temp_files
log_timezone
log_truncate_on_rotation
maintenance_work_mem
max_appendonly_tables
max_connections
max_files_per_process
max_function_args
max_identifier_length
max_index_keys
max_locks_per_transaction
max_prepared_transactions
max_resource_portals_per_transaction
max_resource_queues
max_stack_depth
max_statement_mem
optimizer
optimizer_array_expansion_threshold
optimizer_analyze_root_partition
optimizer_control
optimizer_cte_inlining_bound
optimizer_enable_associativity
optimizer_enable_master_only_queries
optimizer_force_agg_skew_avoidance
optimizer_force_multistage_agg
optimizer_force_three_stage_scalar_dqa
optimizer_join_arity_for_associativity_commutativity
optimizer_join_order
optimizer_join_order_threshold
optimizer_mdcache_size
optimizer_metadata_caching
optimizer_minidump
optimizer_nestloop_factor
optimizer_parallel_union
optimizer_print_missing_stats
optimizer_print_optimization_stats
optimizer_sort_factor
password_encryption
password_hash_algorithm
pljava_classpath
pljava_classpath_insecure
pljava_statement_cache_size
pljava_release_lingering_savepoints
pljava_vmoptions
port
random_page_cost
readable_external_table_timeout
repl_catchup_within_range
replication_timeout
regex_flavor
resource_cleanup_gangs_on_wait
resource_select_only
runaway_detector_activation_percent
search_path
seq_page_cost
server_encoding
server_version
server_version_num
shared_buffers
shared_preload_libraries
ssl
ssl_ciphers
standard_conforming_strings
statement_mem
statement_timeout
stats_queue_level
superuser_reserved_connections
tcp_keepalives_count
tcp_keepalives_idle
tcp_keepalives_interval
temp_buffers
TimeZone
timezone_abbreviations
track_activity_query_size
transaction_isolation
transaction_read_only
transform_null_equals
unix_socket_directory
unix_socket_group
unix_socket_permissions
update_process_title
vacuum_cost_delay
vacuum_cost_limit
vacuum_cost_page_dirty
vacuum_cost_page_hit
vacuum_cost_page_miss
vacuum_freeze_min_age
validate_previous_free_tid
verify_gpfdists_cert
vmem_process_interrupt
wal_receiver_status_interval
writable_external_table_bufsize
xid_stop_limit
xid_warn_limit
内置函数摘要
Greenplum MapReduce规范
Greenplum PL/pgSQL过程语言
Greenplum PL/R 语言扩展
Greenplum PL/Python语言扩展
Greenplum PL/Container语言扩展
Greenplum的PL/Java语言扩展
Greenplum的PL/Perl语言扩展
用于分析的Greenplum MADlib扩展
附加提供的模块
citext
dblink
fuzzystrmatch
gp_sparse_vector
hstore
orafce
pageinspect
pgcrypto
Greenplum Partner Connector API
后台工作进程
Greenplum 特点概要
Greenplum数据库参考指南
Greenplum数据库参考指南
Greenplum数据库系统的参考信息,包括SQL命令,系统catalog,环境变量,服务器配置参数,字符集支持,数据类型和Greenplum数据库扩展。
SQL Command Reference
SQL 2008可选特性兼容性
Greenplum环境变量
保留标识符和SQL关键字
系统目录参考
gp_toolkit管理模式
gpperfmon 数据库
Greenplum 数据库数据类型
字符集支持
服务器配置参数
内置函数摘要
Greenplum MapReduce规范
Greenplum PL/pgSQL过程语言
Greenplum PL/R 语言扩展
Greenplum PL/Python语言扩展
Greenplum PL/Container语言扩展
Greenplum的PL/Java语言扩展
Greenplum的PL/Perl语言扩展
用于分析的Greenplum MADlib扩展
附加提供的模块
Greenplum Partner Connector API
后台工作进程
Greenplum 特点概要