Support
Downloads
Contact Us
Sign In
Pivotal Greenplum v5.28
  • v6.x
  • v5.28
  • v5.27
  • v5.26
  • v5.25
  • v5.24
  • v5.23
  • v5.22
  • v5.21
  • v5.20
  • v5.19
  • v5.18
  • v5.17
  • v5.16
  • v5.15
  • v5.14
  • v5.13
  • v5.12
  • v5.11
  • v5.10
  • v5.9
  • v5.8
  • v5.7
  • v5.6
  • v5.5
  • v5.4
  • v5.3
  • v5.2
  • v5.1
  • v5.0
  • v4.3.x
All docs
Downloads
Support
Contact Us
Sign In
Doc Index
  • Pivotal Greenplum® 5.28 Documentation
  • Reference Guide
    • SQL Command Reference
      • SQL Syntax Summary
      • 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
      • ALTER OPERATOR CLASS
      • ALTER OPERATOR FAMILY
      • ALTER PROTOCOL
      • ALTER RESOURCE GROUP
      • ALTER RESOURCE QUEUE
      • ALTER ROLE
      • ALTER SCHEMA
      • ALTER SEQUENCE
      • ALTER TABLE
      • ALTER TABLESPACE
      • ALTER TYPE
      • ALTER USER
      • ALTER VIEW
      • ANALYZE
      • BEGIN
      • CHECKPOINT
      • CLOSE
      • CLUSTER
      • COMMENT
      • COMMIT
      • COPY
      • CREATE AGGREGATE
      • CREATE CAST
      • CREATE CONVERSION
      • CREATE DATABASE
      • CREATE DOMAIN
      • CREATE EXTENSION
      • CREATE EXTERNAL 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 TABLE
      • CREATE TABLE AS
      • 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
      • 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 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
      • ROLLBACK TO SAVEPOINT
      • SAVEPOINT
      • SELECT
      • SELECT INTO
      • SET
      • SET ROLE
      • SET SESSION AUTHORIZATION
      • SET TRANSACTION
      • SHOW
      • START TRANSACTION
      • TRUNCATE
      • UPDATE
      • VACUUM
      • VALUES
    • SQL 2008 Optional Feature Compliance
    • Greenplum Environment Variables
    • System Catalog Reference
      • System Tables
      • System Views
      • System Catalogs Definitions
        • gp_configuration_history
        • 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_persistent_database_node
        • gp_persistent_filespace_node
        • gp_persistent_relation_node
        • gp_persistent_tablespace_node
        • gp_pgdatabase
        • gp_relation_node
        • gp_resgroup_config
        • gp_resgroup_status
        • gp_resqueue_status
        • 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_depend
        • pg_description
        • pg_enum
        • pg_extension
        • pg_exttable
        • pg_filespace
        • pg_filespace_entry
        • pg_index
        • pg_inherits
        • pg_language
        • pg_largeobject
        • pg_listener
        • pg_locks
        • pg_max_external_files
        • pg_namespace
        • pg_opclass
        • pg_operator
        • 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_all_indexes
        • pg_stat_all_tables
        • 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_window
    • The gp_toolkit Administrative Schema
      • Checking for Tables that Need Routine Maintenance
      • Checking for Locks
      • Checking Append-Optimized Tables
      • Viewing Greenplum Database Server Log Files
      • Checking Server Configuration Files
      • Checking for Failed Segments
      • Checking Resource Group Activity and Status
      • Checking Resource Queue Activity and Status
      • Checking Query Disk Spill Space Usage
      • Viewing Users and Groups (Roles)
      • Checking Database Object Sizes and Disk Space
      • Checking for Uneven Data Distribution
    • The gpperfmon Database
      • database_*
      • diskspace_*
      • interface_stats_*
      • log_alert_*
      • queries_*
      • segment_*
      • socket_stats_*
      • system_*
      • dynamic_memory_info
      • memory_info
    • Greenplum Database Data Types
    • Character Set Support
    • Server Configuration Parameters
      • Parameter Types and Values
      • Setting Parameters
      • Parameter Categories
      • Configuration Parameters
        • add_missing_from
        • 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
        • custom_variable_classes
        • 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_transaction_isolation
        • default_transaction_read_only
        • dtx_phase2_retry_count
        • 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
        • filerep_mirrorvalidation_during_resync
        • from_collapse_limit
        • gp_adjust_selectivity_for_outerjoins
        • gp_analyze_relative_error
        • gp_appendonly_compaction
        • gp_appendonly_compaction_threshold
        • gp_autostats_mode
        • gp_autostats_mode_in_functions
        • gp_autostats_on_change_threshold
        • gp_backup_directIO
        • gp_backup_directIO_read_chunk_mb
        • gp_cached_segworkers_threshold
        • gp_command_count
        • gp_connection_send_timeout
        • gp_connections_per_thread
        • gp_content
        • gp_create_table_random_default_distribution
        • gp_dbid
        • gp_debug_linger
        • gp_default_storage_options
        • gp_dynamic_partition_pruning
        • gp_email_from
        • gp_email_smtp_password
        • gp_email_smtp_server
        • gp_email_smtp_userid
        • gp_email_to
        • gp_enable_agg_distinct
        • gp_enable_agg_distinct_pruning
        • gp_enable_direct_dispatch
        • gp_enable_exchange_default_partition
        • gp_enable_fallback_plan
        • 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_relsize_collection
        • gp_enable_segment_copy_checking
        • gp_enable_sequential_window_plans (Beta)
        • gp_enable_sort_distinct
        • gp_enable_sort_limit
        • gp_external_enable_exec
        • gp_external_max_segs
        • gp_external_enable_filter_pushdown
        • gp_filerep_tcp_keepalives_count
        • gp_filerep_tcp_keepalives_idle
        • gp_filerep_tcp_keepalives_interval
        • gp_fts_probe_interval
        • gp_fts_probe_retries
        • gp_fts_probe_threadcount
        • gp_fts_probe_timeout
        • gp_gpperfmon_send_interval
        • gpperfmon_log_alert_level
        • gp_hadoop_home
        • gp_hadoop_target_version
        • gp_hashjoin_tuples_per_bucket
        • gp_idf_deduplicate
        • gp_ignore_error_table
        • gp_initial_bad_row_limit
        • 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_transmit_timeout
        • gp_interconnect_type
        • gp_log_format
        • gp_log_fts
        • gp_log_gang
        • gp_log_interconnect
        • gp_max_csv_line_length
        • gp_max_databases
        • gp_max_filespaces
        • gp_max_local_distributed_cache
        • gp_max_packet_size
        • gp_max_plan_size
        • gp_max_slices
        • gp_max_tablespaces
        • gp_motion_cost_per_row
        • gp_num_contents_in_cluster
        • gp_recursive_cte_prototype
        • gp_reject_percent_threshold
        • gp_reraise_signal
        • gp_resgroup_memory_policy
        • gp_resource_group_bypass
        • gp_resource_group_cpu_limit
        • gp_resource_group_memory_limit
        • gp_resource_group_queuing_timeout
        • gp_resource_manager
        • gp_resqueue_memory_policy
        • gp_resqueue_priority
        • gp_resqueue_priority_cpucores_per_segment
        • gp_resqueue_priority_sweeper_interval
        • 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_snmp_community
        • gp_snmp_monitor_address
        • gp_snmp_use_inform_or_trap
        • gp_statistics_pullup_from_child_partition
        • gp_statistics_use_fkeys
        • gp_vmem_idle_resource_timeout
        • gp_vmem_protect_limit
        • gp_vmem_protect_segworker_cache_limit
        • gp_workfile_checksumming
        • gp_workfile_compress_algorithm
        • 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
        • 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
        • max_appendonly_tables
        • max_connections
        • max_files_per_process
        • max_fsm_pages
        • max_fsm_relations
        • 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
        • memory_spill_ratio
        • optimizer
        • optimizer_array_expansion_threshold
        • optimizer_analyze_root_partition
        • optimizer_control
        • optimizer_cost_model
        • optimizer_cte_inlining_bound
        • optimizer_enable_associativity
        • optimizer_enable_dml
        • 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_penalize_skew
        • optimizer_print_missing_stats
        • optimizer_print_optimization_stats
        • optimizer_sort_factor
        • optimizer_use_gpdb_allocators
        • password_encryption
        • password_hash_algorithm
        • pgcrypto.fips
        • pgstat_track_activity_query_size
        • 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_activities
        • track_activity_query_size
        • track_counts
        • 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
    • Summary of Built-in Functions
    • Greenplum MapReduce Specification
    • Greenplum PL/pgSQL Procedural Language
    • Greenplum PostGIS Extension
    • Greenplum PL/R Language Extension
    • Greenplum PL/Python Language Extension
    • PL/Container Language
    • Greenplum PL/Java Language Extension
    • Greenplum PL/Perl Language Extension
    • Greenplum MADlib Extension for Analytics
    • Greenplum Partner Connector API
    • Greenplum Fuzzy String Match Extension
    • Summary of Greenplum Features

  • Pivotal Greenplum® 5.28 Documentation
  • Reference Guide
    • SQL Command Reference
      • SQL Syntax Summary
      • 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
      • ALTER OPERATOR CLASS
      • ALTER OPERATOR FAMILY
      • ALTER PROTOCOL
      • ALTER RESOURCE GROUP
      • ALTER RESOURCE QUEUE
      • ALTER ROLE
      • ALTER SCHEMA
      • ALTER SEQUENCE
      • ALTER TABLE
      • ALTER TABLESPACE
      • ALTER TYPE
      • ALTER USER
      • ALTER VIEW
      • ANALYZE
      • BEGIN
      • CHECKPOINT
      • CLOSE
      • CLUSTER
      • COMMENT
      • COMMIT
      • COPY
      • CREATE AGGREGATE
      • CREATE CAST
      • CREATE CONVERSION
      • CREATE DATABASE
      • CREATE DOMAIN
      • CREATE EXTENSION
      • CREATE EXTERNAL 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 TABLE
      • CREATE TABLE AS
      • 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
      • 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 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
      • ROLLBACK TO SAVEPOINT
      • SAVEPOINT
      • SELECT
      • SELECT INTO
      • SET
      • SET ROLE
      • SET SESSION AUTHORIZATION
      • SET TRANSACTION
      • SHOW
      • START TRANSACTION
      • TRUNCATE
      • UPDATE
      • VACUUM
      • VALUES
    • SQL 2008 Optional Feature Compliance
    • Greenplum Environment Variables
    • System Catalog Reference
      • System Tables
      • System Views
      • System Catalogs Definitions
        • gp_configuration_history
        • 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_persistent_database_node
        • gp_persistent_filespace_node
        • gp_persistent_relation_node
        • gp_persistent_tablespace_node
        • gp_pgdatabase
        • gp_relation_node
        • gp_resgroup_config
        • gp_resgroup_status
        • gp_resqueue_status
        • 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_depend
        • pg_description
        • pg_enum
        • pg_extension
        • pg_exttable
        • pg_filespace
        • pg_filespace_entry
        • pg_index
        • pg_inherits
        • pg_language
        • pg_largeobject
        • pg_listener
        • pg_locks
        • pg_max_external_files
        • pg_namespace
        • pg_opclass
        • pg_operator
        • 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_all_indexes
        • pg_stat_all_tables
        • 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_window
    • The gp_toolkit Administrative Schema
      • Checking for Tables that Need Routine Maintenance
      • Checking for Locks
      • Checking Append-Optimized Tables
      • Viewing Greenplum Database Server Log Files
      • Checking Server Configuration Files
      • Checking for Failed Segments
      • Checking Resource Group Activity and Status
      • Checking Resource Queue Activity and Status
      • Checking Query Disk Spill Space Usage
      • Viewing Users and Groups (Roles)
      • Checking Database Object Sizes and Disk Space
      • Checking for Uneven Data Distribution
    • The gpperfmon Database
      • database_*
      • diskspace_*
      • interface_stats_*
      • log_alert_*
      • queries_*
      • segment_*
      • socket_stats_*
      • system_*
      • dynamic_memory_info
      • memory_info
    • Greenplum Database Data Types
    • Character Set Support
    • Server Configuration Parameters
      • Parameter Types and Values
      • Setting Parameters
      • Parameter Categories
      • Configuration Parameters
        • add_missing_from
        • 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
        • custom_variable_classes
        • 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_transaction_isolation
        • default_transaction_read_only
        • dtx_phase2_retry_count
        • 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
        • filerep_mirrorvalidation_during_resync
        • from_collapse_limit
        • gp_adjust_selectivity_for_outerjoins
        • gp_analyze_relative_error
        • gp_appendonly_compaction
        • gp_appendonly_compaction_threshold
        • gp_autostats_mode
        • gp_autostats_mode_in_functions
        • gp_autostats_on_change_threshold
        • gp_backup_directIO
        • gp_backup_directIO_read_chunk_mb
        • gp_cached_segworkers_threshold
        • gp_command_count
        • gp_connection_send_timeout
        • gp_connections_per_thread
        • gp_content
        • gp_create_table_random_default_distribution
        • gp_dbid
        • gp_debug_linger
        • gp_default_storage_options
        • gp_dynamic_partition_pruning
        • gp_email_from
        • gp_email_smtp_password
        • gp_email_smtp_server
        • gp_email_smtp_userid
        • gp_email_to
        • gp_enable_agg_distinct
        • gp_enable_agg_distinct_pruning
        • gp_enable_direct_dispatch
        • gp_enable_exchange_default_partition
        • gp_enable_fallback_plan
        • 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_relsize_collection
        • gp_enable_segment_copy_checking
        • gp_enable_sequential_window_plans (Beta)
        • gp_enable_sort_distinct
        • gp_enable_sort_limit
        • gp_external_enable_exec
        • gp_external_max_segs
        • gp_external_enable_filter_pushdown
        • gp_filerep_tcp_keepalives_count
        • gp_filerep_tcp_keepalives_idle
        • gp_filerep_tcp_keepalives_interval
        • gp_fts_probe_interval
        • gp_fts_probe_retries
        • gp_fts_probe_threadcount
        • gp_fts_probe_timeout
        • gp_gpperfmon_send_interval
        • gpperfmon_log_alert_level
        • gp_hadoop_home
        • gp_hadoop_target_version
        • gp_hashjoin_tuples_per_bucket
        • gp_idf_deduplicate
        • gp_ignore_error_table
        • gp_initial_bad_row_limit
        • 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_transmit_timeout
        • gp_interconnect_type
        • gp_log_format
        • gp_log_fts
        • gp_log_gang
        • gp_log_interconnect
        • gp_max_csv_line_length
        • gp_max_databases
        • gp_max_filespaces
        • gp_max_local_distributed_cache
        • gp_max_packet_size
        • gp_max_plan_size
        • gp_max_slices
        • gp_max_tablespaces
        • gp_motion_cost_per_row
        • gp_num_contents_in_cluster
        • gp_recursive_cte_prototype
        • gp_reject_percent_threshold
        • gp_reraise_signal
        • gp_resgroup_memory_policy
        • gp_resource_group_bypass
        • gp_resource_group_cpu_limit
        • gp_resource_group_memory_limit
        • gp_resource_group_queuing_timeout
        • gp_resource_manager
        • gp_resqueue_memory_policy
        • gp_resqueue_priority
        • gp_resqueue_priority_cpucores_per_segment
        • gp_resqueue_priority_sweeper_interval
        • 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_snmp_community
        • gp_snmp_monitor_address
        • gp_snmp_use_inform_or_trap
        • gp_statistics_pullup_from_child_partition
        • gp_statistics_use_fkeys
        • gp_vmem_idle_resource_timeout
        • gp_vmem_protect_limit
        • gp_vmem_protect_segworker_cache_limit
        • gp_workfile_checksumming
        • gp_workfile_compress_algorithm
        • 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
        • 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
        • max_appendonly_tables
        • max_connections
        • max_files_per_process
        • max_fsm_pages
        • max_fsm_relations
        • 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
        • memory_spill_ratio
        • optimizer
        • optimizer_array_expansion_threshold
        • optimizer_analyze_root_partition
        • optimizer_control
        • optimizer_cost_model
        • optimizer_cte_inlining_bound
        • optimizer_enable_associativity
        • optimizer_enable_dml
        • 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_penalize_skew
        • optimizer_print_missing_stats
        • optimizer_print_optimization_stats
        • optimizer_sort_factor
        • optimizer_use_gpdb_allocators
        • password_encryption
        • password_hash_algorithm
        • pgcrypto.fips
        • pgstat_track_activity_query_size
        • 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_activities
        • track_activity_query_size
        • track_counts
        • 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
    • Summary of Built-in Functions
    • Greenplum MapReduce Specification
    • Greenplum PL/pgSQL Procedural Language
    • Greenplum PostGIS Extension
    • Greenplum PL/R Language Extension
    • Greenplum PL/Python Language Extension
    • PL/Container Language
    • Greenplum PL/Java Language Extension
    • Greenplum PL/Perl Language Extension
    • Greenplum MADlib Extension for Analytics
    • Greenplum Partner Connector API
    • Greenplum Fuzzy String Match Extension
    • Summary of Greenplum Features
Privacy Policy | Terms of Use

Copyright © 2021 VMware, Inc. or its affiliates. All Rights Reserved.

Need help? Visit Support
Release Notes
Download
Ask for Help
Knowledge Base
PDF