我的书签
添加书签
移除书签Routine System Maintenance Tasks
- Getting Started with HAWQ Tutorial
- HAWQ Reference
- HAWQ Management Tools Reference
- Data Types
- Character Set Support Reference
- SQL Commands
- END
- CREATE DATABASE
- COPY
- DROP GROUP
- CREATE CAST
- DROP SCHEMA
- ALTER CONVERSION
- ALTER ROLE
- COMMIT
- ALTER AGGREGATE
- BEGIN
- PREPARE
- ABORT
- CREATE AGGREGATE
- FETCH
- CLOSE
- EXPLAIN
- DROP CAST
- ALTER TABLE
- SET
- ALTER FUNCTION
- CREATE VIEW
- DROP ROLE
- CREATE USER
- ANALYZE
- RESET
- SAVEPOINT
- ALTER TABLESPACE
- CREATE CONVERSION
- DROP DATABASE
- DROP USER
- SELECT
- GRANT
- CREATE TABLE
- DROP TYPE
- RELEASE SAVEPOINT
- REVOKE
- DROP TABLE
- INSERT
- DROP FUNCTION
- CREATE TABLESPACE
- CREATE OPERATOR
- DROP OPERATOR CLASS
- ALTER OPERATOR CLASS
- CREATE FUNCTION
- SHOW
- ALTER USER
- DROP LANGUAGE
- CREATE OPERATOR CLASS
- CREATE TYPE
- TRUNCATE
- DROP FILESPACE
- ALTER SEQUENCE
- ROLLBACK
- CREATE RESOURCE QUEUE
- CREATE GROUP
- CREATE TABLE AS
- DROP EXTERNAL TABLE
- ALTER TYPE
- DROP OPERATOR
- SET ROLE
- CREATE EXTERNAL TABLE
- DROP CONVERSION
- DROP RESOURCE QUEUE
- CREATE SEQUENCE
- ALTER DATABASE
- DROP SEQUENCE
- ROLLBACK TO SAVEPOINT
- DECLARE
- REASSIGN OWNED
- CHECKPOINT
- ALTER OPERATOR
- SELECT INTO
- CREATE ROLE
- DROP TABLESPACE
- SET SESSION AUTHORIZATION
- CREATE SCHEMA
- VACUUM
- DROP AGGREGATE
- DROP VIEW
- DEALLOCATE
- EXECUTE
- CREATE LANGUAGE
- DROP OWNED
- ALTER RESOURCE QUEUE
- The hawq_toolkit Administrative Schema
- Server Configuration Parameter Reference
- Configuration Parameters
- pxf_enable_filter_pushdown
- hawq_rm_nvseg_perquery_perseg_limit
- gp_reject_percent_threshold
- gp_filerep_tcp_keepalives_idle
- krb_caseins_users
- log_min_duration_statement
- gp_external_enable_exec
- block_size
- hawq_rm_yarn_address
- gp_enable_direct_dispatch
- server_version_num
- hawq_rm_rejectrequest_nseg_limit
- hawq_rm_stmt_nvseg
- hawq_rm_tolerate_nseg_limit
- vacuum_cost_page_dirty
- log_duration
- server_version
- gp_role
- search_path
- integer_datetimes
- bonjour_name
- enable_nestloop
- krb_server_keyfile
- gp_autostats_mode
- gp_external_max_segs
- hawq_dfs_url
- cpu_tuple_cost
- enable_sort
- server_encoding
- application_name
- hawq_master_address_host
- standard_conforming_strings
- lc_messages
- lc_monetary
- log_rotation_age
- optimizer_analyze_root_partition
- gp_enable_agg_distinct_pruning
- hawq_rm_memory_limit_perseg
- pxf_stat_max_fragments
- gp_adjust_selectivity_for_outerjoins
- gp_enable_multiphase_agg
- cpu_index_tuple_cost
- debug_print_parse
- gp_interconnect_default_rtt
- gp_log_format
- hawq_rm_nresqueue_limit
- debug_print_rewritten
- gp_workfile_limit_per_segment
- hawq_rps_address_port
- gp_statistics_use_fkeys
- hawq_rm_nslice_perseg_limit
- TimeZone
- log_parser_stats
- gp_vmem_protect_segworker_cache_limit
- gp_backup_directIO_read_chunk_mb
- effective_cache_size
- enable_hashjoin
- superuser_reserved_connections
- gp_idf_deduplicate
- gp_interconnect_snd_queue_depth
- gp_debug_linger
- log_statement_stats
- gp_enable_sequential_window_plans
- default_tablespace
- dynamic_library_path
- gp_enable_groupext_distinct_gather
- gp_segments_for_planner
- optimizer_prefer_scalar_dqa_multistage_agg
- hawq_global_rm_type
- log_min_error_statement
- gp_max_plan_size
- gp_interconnect_queue_depth
- pljava_release_lingering_savepoints
- enable_groupagg
- unix_socket_permissions
- gp_enable_groupext_distinct_pruning
- default_hash_table_bucket_number
- debug_print_slice_table
- gp_max_filespaces
- escape_string_warning
- optimizer
- gp_backup_directIO
- regex_flavor
- hawq_rm_nvseg_variance_amon_seg_limit
- hawq_rm_yarn_app_name
- debug_pretty_print
- unix_socket_directory
- pxf_enable_stat_collection
- enable_mergejoin
- gp_enable_sort_distinct
- gp_workfile_compress_algorithm
- gp_interconnect_setup_timeout
- gp_workfile_checksumming
- max_appendonly_tables
- gp_autostats_on_change_threshhold
- gp_analyze_relative_error
- hawq_re_memory_overcommit_max
- optimizer_parts_to_force_sort_on_insert
- hawq_segment_directory
- gp_enable_sort_limit
- hawq_rm_master_port
- gp_set_proc_affinity
- enable_bitmapscan
- hawq_rm_return_percent_on_overcommit
- gp_enable_preunique
- hawq_acl_type
- tcp_keepalives_idle
- log_rotation_size
- deadlock_timeout
- enable_hashagg
- gp_command_count
- hawq_rm_nvseg_perquery_limit
- log_hostname
- gp_vmem_idle_resource_timeout
- add_missing_from
- gp_set_read_only
- hawq_rm_yarn_scheduler_address
- listen_addresses
- log_truncate_on_rotation
- temp_buffers
- ssl_ciphers
- client_encoding
- join_collapse_limit
- gp_max_csv_line_length
- gp_filerep_tcp_keepalives_interval
- hawq_rm_nvcore_limit_perseg
- local_preload_libraries
- vacuum_freeze_min_age
- gp_hashjoin_tuples_per_bucket
- gp_enable_fast_sri
- max_connections
- default_transaction_isolation
- max_function_args
- tcp_keepalives_interval
- max_locks_per_transaction
- gp_statistics_pullup_from_child_partition
- krb_srvname
- lc_time
- seq_page_cost
- hawq_rm_yarn_queue_name
- enable_indexscan
- pxf_service_port
- gp_interconnect_timer_period
- pljava_classpath
- hawq_rm_force_alterqueue_cancel_queued_request
- ssl
- max_fsm_relations
- gp_interconnect_timer_checking_period
- client_min_messages
- backslash_quote
- IntervalStyle
- custom_variable_classes
- gp_interconnect_min_rto
- gp_cached_segworkers_threshold
- statement_timeout
- from_collapse_limit
- log_min_messages
- log_disconnections
- extra_float_digits
- vacuum_cost_page_miss
- array_nulls
- cursor_tuple_fraction
- gp_enable_agg_distinct
- pxf_service_address
- explain_pretty_print
- gp_workfile_limit_per_query
- gp_reraise_signal
- hawq_rm_segment_port
- transform_null_equals
- log_executor_stats
- gp_motion_cost_per_row
- gp_dynamic_partition_pruning
- optimizer_minidump
- log_dispatch_stats
- random_page_cost
- debug_assertions
- log_error_verbosity
- track_activities
- hawq_segment_temp_directory
- check_function_bodies
- hawq_rm_stmt_vseg_memory
- gp_max_databases
- gp_interconnect_fc_method
- log_connections
- gp_connections_per_thread
- gp_interconnect_cache_future_packets
- seg_max_connections
- hawq_rm_cluster_report_period
- log_timezone
- gp_interconnect_hash_multiplier
- hawq_rm_resource_idle_timeout
- log_statement
- gp_enable_fallback_plan
- hawq_master_temp_directory
- max_identifier_length
- default_transaction_read_only
- log_autostats
- max_stack_depth
- pgstat_track_activity_query_size
- server_ticket_renew_interval
- vacuum_cost_delay
- hawq_master_address_port
- lc_ctype
- debug_print_plan
- lc_numeric
- gp_segment_connect_timeout
- gp_external_grant_privileges
- enable_tidscan
- transaction_read_only
- port
- pxf_remote_service_login
- authentication_timeout
- gp_max_packet_size
- gp_safefswritesize
- password_encryption
- db_user_namespace
- gp_interconnect_type
- gp_filerep_tcp_keepalives_count
- DateStyle
- enable_seqscan
- hawq_rm_segment_heartbeat_interval
- gp_interconnect_min_retries_before_timeout
- gp_workfile_limit_files_per_query
- max_fsm_pages
- lc_collate
- pljava_statement_cache_size
- cpu_operator_cost
- vacuum_cost_limit
- log_planner_stats
- runaway_detector_activation_percent
- hawq_master_directory
- shared_buffers
- hawq_rm_min_resource_perseg
- shared_preload_libraries
- gp_max_tablespaces
- max_prepared_transactions
- update_process_title
- hawq_rps_check_local_interval
- timezone_abbreviations
- transaction_isolation
- pxf_remote_service_secret
- default_statistics_target
- max_files_per_process
- track_counts
- max_index_keys
- xid_stop_limit
- debug_print_prelim_plan
- tcp_keepalives_count
- pljava_vmoptions
- gp_session_id
- unix_socket_group
- hawq_segment_address_port
- gp_enable_predicate_propagation
- Configuration Parameter Categories
- Ranger Configuration Parameters
- Query Tuning Parameters
- Past PostgreSQL Version Compatibility Parameters
- External Table Parameters
- Append-Only Table Parameters
- System Resource Consumption Parameters
- Error Reporting and Logging Parameters
- Database and Tablespace/Filespace Parameters
- Client Connection Default Parameters
- Connection and Authentication Parameters
- HAWQ PL/Java Extension Parameters
- Statistics Collection Parameters
- Lock Management Parameters
- HAWQ Array Configuration Parameters
- GPORCA Parameters
- HAWQ Resource Management Parameters
- HAWQ Extension Framework (PXF) Parameters
- Sample hawq-site.xml Configuration File
- About Server Configuration Parameters
- Configuration Parameters
- HDFS Configuration Reference
- Environment Variables
- System Catalog Reference
- System Tables
- System Views
- System Catalogs Definitions
- pg_partition_encoding
- pg_exttable
- pg_largeobject
- pg_filespace
- pg_locks
- pg_partition_rule
- gp_master_mirroring
- pg_description
- pg_stat_last_operation
- pg_window
- pg_amproc
- pg_namespace
- pg_tablespace
- gp_persistent_database_node
- pg_pltemplate
- pg_rewrite
- pg_partition
- pg_attribute_encoding
- gp_persistent_relation_node
- pg_aggregate
- pg_authid
- pg_auth_members
- pg_database
- pg_stat_activity
- pg_attribute
- pg_resqueue_status
- gp_segment_configuration
- pg_conversion
- pg_partition_columns
- pg_constraint
- pg_stats
- pg_partition_templates
- gp_relfile_node
- pg_proc
- gp_persistent_relfile_node
- pg_listener
- pg_index
- pg_resqueue
- pg_stat_partition_operations
- pg_appendonly
- pg_am
- pg_statistic
- pg_type_encoding
- pg_operator
- pg_shdepend
- gp_global_sequence
- pg_class
- pg_opclass
- pg_roles
- pg_trigger
- pg_language
- pg_shdescription
- pg_stat_last_shoperation
- pg_compression
- pg_inherits
- pg_partitions
- pg_amop
- pg_filespace_entry
- gp_version_at_initdb
- pg_depend
- pg_stat_operations
- pg_cast
- pg_attrdef
- gp_distribution_policy
- pg_type
- gp_configuration_history
- gp_persistent_tablespace_node
- gp_persistent_filespace_node
- Best Practices
- System Requirements
- Defining Database Objects
- Managing Data with HAWQ
- Concurrency Control
- Loading and Unloading Data
- Optimizing Data Load and Query Performance
- Using the HAWQ File Server (gpfdist)
- Working with File-Based External Tables
- Loading Data with COPY
- Loading Data Using an External Table
- Transforming XML Data
- Loading Data with hawq load
- Unloading Data from HAWQ
- Creating and Using Web External Tables
- Formatting Data Files
- Registering Files into HAWQ Internal Tables
- Handling Load Errors
- Running COPY in Single Row Error Isolation Mode
- Creating External Tables - Examples
- Loading and Writing Non-HDFS Custom Data
- Basic Data Operations
- HAWQ InputFormat for MapReduce
- About Database Statistics
- Working with Transactions
- Using PXF with Unmanaged Data
- Querying Data
- Troubleshooting
- HAWQ System Overview
- Managing Client Access
- Connecting with psql
- Using Kerberos Authentication
- Overview of HAWQ Authorization
- Using HAWQ Native Authorization
- Disabling Kerberos Security
- Establishing a Database Session
- Configuring Client Authentication
- Using LDAP Authentication with TLS/SSL
- HAWQ Client Applications
- Troubleshooting Connection Problems
- HAWQ Database Drivers and APIs
- Using Ranger for Authorization
- Managing Resources
- Running a HAWQ Cluster
- HAWQ Filespaces and High Availability Enabled HDFS
- Monitoring a HAWQ System
- Backing Up and Restoring HAWQ
- Introducing the HAWQ Operating Environment
- Expanding a Cluster
- Recommended Monitoring and Maintenance Tasks
- Starting and Stopping HAWQ
- HAWQ Administrative Log Files
- Managing HAWQ Using Ambari
- High Availability in HAWQ
- Overview
- Master Mirroring
- Routine System Maintenance Tasks
- Removing a Node
- HAWQ Packcore Utility
- Understanding the Fault Tolerance Service
- Using Procedural Languages
暂无相关搜索结果！
本文档使用 全库网 构建
