我的书签
添加书签
移除书签GPORCA also enhances Greenplum Database query performance tuning in the following areas:
The following figure shows how GPORCA fits into the query planning architecture.
Parent topic:
Overview of GPORCA
- Concepts
- Best Practices
- System Monitoring and Maintenance
- Memory and Resource Management with Resource Queues
- Loading Data
- Encrypting Data and Database Connections
- High Availability
- Identifying and Mitigating Heap Table Performance Issues
- Memory and Resource Management with Resource Groups
- Schema Design
- Best Practices Summary
- Security
- System Configuration
- Tuning SQL Queries
- System Administration
- Configuring the Greenplum Database System
- About the Greenplum Database Release Version Number
- Starting and Stopping Greenplum Database
- Recommended Monitoring and Maintenance Tasks
- Expanding a Greenplum System
- Routine System Maintenance Tasks
- Accessing the Database
- Configuring Proxies for the Greenplum Interconnect
- Migrating Data with gpcopy
- Managing Database Access
- Enabling Compression
- Enabling High Availability and Data Consistency Features
- Backing Up and Restoring Databases
- Monitoring a Greenplum System
- Release Notes
- Server Programmatic Interfaces
- Managing Performance
- Securing Your System
- Platform Requirements
- Version 6.23
- Deploying to VMware vSphere
- Architecture
- Choosing Your Deployment Option
- Planning Downtime for Maintenance
- Planning VMware vSphere with Greenplum
- Managing Single Host Failures in vSphere
- Creating the Jumpbox Virtual Machine
- Validating the Greenplum Installation
- Setting Up VMware vSphere Storage
- Setting Up VMware vSphere Encryption
- Overview
- Validating VMware vSphere Setup Performance with HCI Bench
- Prerequisites
- Setting Up VMware vSphere Network
- Setting Up VMware vSphere DRS and HA
- Reference
- System Catalogs
- System Catalogs Definitions
- gp_distribution_policy
- pg_partition_rule
- pg_stat_last_operation
- pg_resqueue_attributes
- pg_matviews
- pg_attribute_encoding
- pg_namespace
- pg_largeobject
- user_mapping_options
- foreign_servers
- pg_roles
- gp_configuration_history
- pg_stat_operations
- gpexpand.expansion_progress
- pg_database
- pg_stat_replication
- gp_resgroup_config
- pg_stat_resqueues
- pg_inherits
- pg_opclass
- pg_appendonly
- pg_constraint
- pg_pltemplate
- gp_resqueue_status
- gp_id
- pg_type_encoding
- pg_rules
- gp_session_endpoints
- pg_max_external_files
- pg_user_mapping
- pg_user_mappings
- pg_tablespace
- pg_attribute
- pg_authid
- gp_version_at_initdb
- pg_db_role_setting
- pg_cursors
- pg_foreign_data_wrapper
- pg_resqueue
- pg_partition
- pg_depend
- pg_proc
- pg_resgroup
- pg_trigger
- pg_resqueuecapability
- pg_partition_templates
- gp_segment_endpoints
- gp_transaction_log
- pg_resgroupcapability
- pg_amproc
- pg_amop
- foreign_data_wrapper_options
- pg_stat_all_tables
- pg_description
- foreign_data_wrappers
- gp_distributed_xacts
- gp_resgroup_status_per_host
- pg_extension
- gpexpand.status
- pg_shdescription
- gp_resgroup_status_per_segment
- pg_conversion
- pg_compression
- user_mappings
- pg_am
- pg_opfamily
- pg_shdepend
- pg_foreign_table
- pg_foreign_server
- pg_type
- gp_fastsequence
- gp_endpoints
- pg_auth_members
- gp_stat_replication
- pg_class
- pg_operator
- pg_resourcetype
- pg_partition_columns
- pg_locks
- gp_distributed_log
- pg_stat_last_shoperation
- pg_index
- foreign_table_options
- pg_aggregate
- gp_resgroup_status
- gp_pgdatabase
- pg_available_extensions
- pg_attrdef
- pg_stat_partition_operations
- pg_partitions
- pg_stat_all_indexes
- gp_segment_configuration
- pg_language
- pg_cast
- pg_available_extension_versions
- pg_exttable
- pg_rewrite
- pg_enum
- pg_partition_encoding
- foreign_server_options
- foreign_tables
- gpexpand.status_detail
- pg_stat_activity
- pg_statistic
- System Views
- System Tables
- System Catalogs Definitions
- Data Types
- Database Utilities
- Utility Reference
- clusterdb
- pg_dumpall
- reindexdb
- pg_config
- gprecoverseg
- gpmt
- gpcheckperf
- createdb
- gpssh-exkeys
- pgbouncer.ini
- gpmapreduce
- gpstop
- gpinitstandby
- gpactivatestandby
- pgbouncer
- gpssh
- createuser
- plcontainer Configuration File
- gpreload
- gpaddmirrors
- pg_dump
- gpconfig
- gpcheckcat
- pgbouncer-admin
- vacuumdb
- gpstart
- gpexpand
- gppkg
- gpdeletesystem
- psql
- gpstate
- gpmemwatcher
- dropdb
- gplogfilter
- plcontainer
- gpmemreport
- gpload
- gpmovemirrors
- dropuser
- gpinitsystem
- pg_restore
- gpss
- analyzedb
- gpfdist
- gpmapreduce.yaml
- gpcopy
- gpscp
- About the Greenplum Database Utilities
- Additional Supplied Programs
- Utility Reference
- Character Set Support
- SQL Features, Reserved and Key Words, and Compliance
- Objects Deprecated in Greenplum 6
- The gpperfmon Database
- Server Configuration Parameters
- Summary of Built-in Functions
- SQL Commands
- DROP PROTOCOL
- CREATE FOREIGN DATA WRAPPER
- DROP TEXT SEARCH TEMPLATE
- REVOKE
- DROP OPERATOR FAMILY
- ALTER CONVERSION
- DROP SERVER
- SHOW
- REASSIGN OWNED
- DO
- COPY
- DROP INDEX
- ALTER SEQUENCE
- SQL Syntax Summary
- CREATE USER
- ALTER EXTERNAL TABLE
- ALTER GROUP
- SET SESSION AUTHORIZATION
- DROP TABLE
- DELETE
- CREATE ROLE
- CREATE PROTOCOL
- START TRANSACTION
- ALTER RESOURCE QUEUE
- GRANT
- CREATE INDEX
- CREATE LANGUAGE
- DROP DOMAIN
- DROP OPERATOR
- CREATE DOMAIN
- CREATE SCHEMA
- ALTER OPERATOR
- DROP AGGREGATE
- END
- DROP OWNED
- DROP RESOURCE GROUP
- CREATE TEXT SEARCH PARSER
- SET CONSTRAINTS
- ALTER USER MAPPING
- DROP TABLESPACE
- REINDEX
- ALTER TABLESPACE
- SET TRANSACTION
- COMMIT
- DROP TEXT SEARCH DICTIONARY
- DROP TEXT SEARCH PARSER
- SELECT
- DROP CAST
- DROP TYPE
- VALUES
- DROP FOREIGN TABLE
- ALTER AGGREGATE
- ALTER OPERATOR CLASS
- REFRESH MATERIALIZED VIEW
- SELECT INTO
- CREATE TEXT SEARCH CONFIGURATION
- DROP COLLATION
- RETRIEVE
- COMMENT
- CREATE TABLESPACE
- RESET
- CREATE RESOURCE QUEUE
- CREATE FOREIGN TABLE
- CREATE USER MAPPING
- CREATE VIEW
- LOAD
- DROP TEXT SEARCH CONFIGURATION
- CREATE TYPE
- ALTER VIEW
- DROP CONVERSION
- EXECUTE
- ALTER LANGUAGE
- DROP RESOURCE QUEUE
- CREATE RESOURCE GROUP
- DROP USER
- ALTER TYPE
- BEGIN
- CREATE MATERIALIZED VIEW
- CREATE TEXT SEARCH DICTIONARY
- CREATE FUNCTION
- PREPARE
- DROP SEQUENCE
- CREATE SERVER
- TRUNCATE
- ALTER OPERATOR FAMILY
- DROP SCHEMA
- ALTER DATABASE
- DEALLOCATE
- DROP RULE
- SAVEPOINT
- CREATE OPERATOR FAMILY
- DROP FOREIGN DATA WRAPPER
- DROP GROUP
- CREATE AGGREGATE
- FETCH
- NOTIFY
- DROP MATERIALIZED VIEW
- INSERT
- ROLLBACK
- CLUSTER
- DISCARD
- EXPLAIN
- SET
- CREATE EXTERNAL TABLE
- ALTER COLLATION
- CREATE OPERATOR
- DROP LANGUAGE
- ALTER FUNCTION
- DROP DATABASE
- ALTER RULE
- CHECKPOINT
- SET ROLE
- CREATE CAST
- CREATE DATABASE
- ALTER SCHEMA
- ALTER ROLE
- DECLARE
- ALTER DEFAULT PRIVILEGES
- VACUUM
- ALTER PROTOCOL
- UPDATE
- CREATE TEXT SEARCH TEMPLATE
- CREATE SEQUENCE
- CLOSE
- ABORT
- ALTER INDEX
- CREATE RULE
- DROP EXTENSION
- ROLLBACK TO SAVEPOINT
- ALTER FOREIGN TABLE
- ALTER TABLE
- ALTER DOMAIN
- DROP USER MAPPING
- MOVE
- LOCK
- ALTER FOREIGN DATA WRAPPER
- CREATE TABLE AS
- ALTER RESOURCE GROUP
- CREATE CONVERSION
- ALTER TEXT SEARCH DICTIONARY
- DROP OPERATOR CLASS
- CREATE EXTENSION
- ALTER TEXT SEARCH PARSER
- LISTEN
- CREATE COLLATION
- RELEASE SAVEPOINT
- ALTER TEXT SEARCH CONFIGURATION
- CREATE OPERATOR CLASS
- ALTER TEXT SEARCH TEMPLATE
- ANALYZE
- ALTER MATERIALIZED VIEW
- ALTER USER
- UNLISTEN
- CREATE GROUP
- ALTER SERVER
- DROP ROLE
- DROP FUNCTION
- DROP EXTERNAL TABLE
- ALTER EXTENSION
- DROP VIEW
- CREATE TABLE
- The gp_toolkit Administrative Schema
- Additional Supplied Modules
- System Catalogs
- Installing and Upgrading
- Verifying a Greenplum Database Software Download
- Estimating Storage Capacity
- Greenplum Environment Variables
- Upgrading to Greenplum 6
- Example Ansible Playbook
- Installing Additional Supplied Modules
- Configuring Timezone and Localization Settings
- Installing the Greenplum Database Software
- Configuring Your Systems
- Creating the Data Storage Areas
- Initializing a Greenplum Database System
- Installing Optional Extensions
- Enabling iptables (Optional)
- Validating Your Systems
- Installation Management Utilities
- Managing Data
- Querying Data
- Loading and Unloading Data
- Transforming External Data with gpfdist and gpload
- Formatting Data Files
- Loading Data with gpload
- Greenplum Client and Loader Tools Package
- Example Custom Data Access Protocol
- Accessing External Data with PXF
- Optimizing Data Load and Query Performance
- Loading Data with COPY
- Unloading Data from Greenplum Database
- Loading Data Using an External Table
- Running COPY in Single Row Error Isolation Mode
- Handling Load Errors
- Loading and Writing Non-HDFS Custom Data
- Defining Database Objects
- Using Indexes in Greenplum Database
- Choosing the Table Storage Model
- Creating and Using Sequences
- Partitioning Large Tables
- Creating and Managing Databases
- Creating and Managing Tables
- Creating and Managing Views
- Creating and Managing Tablespaces
- Creating and Managing Schemas
- Creating and Managing Materialized Views
- Advanced Analytics
- Working with External Data
- Defining External Tables
- pxf:// Protocol
- Examples for Creating External Tables
- Example 6—Multiple files in CSV format with header rows
- Example 2—Multiple gpfdist instances
- Example 5—TEXT Format on a Hadoop Distributed File Server
- Example 7—Readable External Web Table with Script
- Example 3—Multiple gpfdists instances
- Example 4—Single gpfdist instance with error logging
- Example 1—Single gpfdist instance on single-NIC machine
- Example 10—Readable and Writable External Tables with XML Transformations
- Example 9—Writable External Web Table with Script
- Example 8—Writable External Table with gpfdist
- s3:// Protocol
- gpfdist:// Protocol
- Using a Custom Protocol
- Handling Errors in External Table Data
- file:// Protocol
- Creating and Using External Web Tables
- gpfdists:// Protocol
- Using the Greenplum Parallel File Server (gpfdist)
- Accessing External Data with Foreign Tables
- Defining External Tables
- Inserting, Updating, and Deleting Data
暂无相关搜索结果！
本文档使用 全库网 构建
