没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
Last Revised: April 28, 2010 2:59 pm
Greenplum Database 4.0
Administrator Guide
Technical Publications
Table of Contents ii
Greenplum Database Administrator Guide 4.0 - Contents
Greenplum Database Administrator Guide 4.0 - Contents
Preface ............................................................................................... 1
About This Guide.............................................................................. 1
Greenplum Database Documentation ............................................... 2
Document Conventions............................................................... 2
Contact Us ....................................................................................... 4
........................................................................................................ 4
Section I: Introduction to Greenplum
Chapter 1: About the Greenplum Architecture........................ 6
About the Greenplum Master............................................................ 7
About the Greenplum Segments....................................................... 7
About the Greenplum Interconnect .................................................. 7
About Redundancy and Failover in Greenplum Database .................. 8
About Segment Mirroring............................................................ 8
About Master Mirroring ............................................................... 9
About Interconnect Redundancy ................................................. 9
About Parallel Data Loading ............................................................10
About Management and Monitoring .................................................10
Chapter 2: About Distributed Databases .................................12
Understanding How Data is Stored..................................................12
Understanding Greenplum Distribution Policies................................13
Chapter 3: Summary of Greenplum Features .........................14
System Requirements .....................................................................14
Feature Summary ...........................................................................15
Greenplum SQL Standard Conformance.....................................15
Greenplum and PostgreSQL Compatibility..................................19
Chapter 4: About Greenplum Query Processing ....................26
Understanding Query Planning and Dispatch ...................................26
Understanding Greenplum Query Plans ...........................................27
Understanding Parallel Query Execution ..........................................28
Section II: Access Control and Security
Chapter 5: Managing Roles and Privileges ..............................31
Security Best Practices for Roles and Privileges...............................31
Creating New Roles (Users).............................................................32
Altering Role Attributes..............................................................32
Creating Groups (Role Membership)................................................33
Managing Object Privileges .............................................................34
Simulating Row and Column Level Access Control .....................35
Encrypting Data ..............................................................................35
Chapter 6: Configuring Client Authentication.........................37
Allowing Connections to Greenplum Database.................................37
Editing the pg_hba.conf File.......................................................38
Limiting Concurrent Connections .....................................................39
Encrypting Client/Server Connections .............................................40
Table of Contents iii
Greenplum Database Administrator Guide 4.0 - Contents
Chapter 7: Accessing the Database...........................................41
Establishing a Database Session .....................................................41
Supported Client Applications..........................................................42
Greenplum Database Client Applications....................................42
pgAdmin III for Greenplum Database ........................................43
Database Application Interfaces.................................................46
Third-Party Client Tools .............................................................47
Troubleshooting Connection Problems .............................................48
Chapter 8: Managing Workload and Resources .....................49
Overview of Greenplum Workload Management ..............................49
How Resource Queues Work in Greenplum Database.................49
Steps to Enable Workload Management .....................................52
Configuring Workload Management .................................................53
Creating Resource Queues ..............................................................54
Creating Queues with an Active Query Limit ..............................54
Creating Queues with a Query Planner Cost Limits ....................54
Setting Priority Levels................................................................55
Assigning Roles (Users) to a Resource Queue..................................56
Removing a Role from a Resource Queue ..................................56
Modifying Resource Queues.............................................................56
Altering a Resource Queue.........................................................57
Dropping a Resource Queue ......................................................57
Checking Resource Queue Status ....................................................57
Viewing Queued Statements and Resource Queue Status ..........57
Viewing Resource Queue Statistics ............................................58
Viewing the Roles Assigned to a Resource Queue ......................58
Viewing the Waiting Queries for a Resource Queue....................58
Clearing a Waiting Statement From a Resource Queue ..............59
Viewing the Priority of Active Statements ..................................60
Resetting the Priority of an Active Statement.............................60
Section III: Database Administration
Chapter 9: Defining Database Objects......................................62
Creating and Managing Databases ..................................................62
About Template Databases ........................................................62
Creating a Database ..................................................................62
Viewing the List of Databases ....................................................63
Altering a Database ...................................................................63
Dropping a Database .................................................................63
Creating and Managing Tablespaces................................................64
Creating a Filespace...................................................................64
Creating a Tablespace ...............................................................65
Using a Tablespace to Store Database Objects ..........................65
Viewing Existing Tablespaces and Filespaces .............................66
Dropping Tablespaces and Filespaces ........................................66
Creating and Managing Schemas.....................................................66
The Default ‘Public’ Schema.......................................................67
Creating a Schema ....................................................................67
Schema Search Paths ................................................................67
Table of Contents iv
Greenplum Database Administrator Guide 4.0 - Contents
Dropping a Schema ...................................................................68
System Schemas .......................................................................68
Creating and Managing Tables ........................................................68
Creating a Table ........................................................................69
Altering a Table .........................................................................75
Dropping a Table .......................................................................77
Partitioning Large Tables.................................................................77
Understanding Table Partitioning in Greenplum Database..........77
Deciding on a Table Partitioning Strategy ..................................78
Creating Partitioned Tables ........................................................79
Loading Partitioned Tables .........................................................82
Verifying Your Partition Strategy................................................83
Viewing Your Partition Design ....................................................84
Maintaining Partitioned Tables ...................................................84
Creating and Using Sequences ........................................................88
Creating a Sequence..................................................................88
Using a Sequence ......................................................................88
Altering a Sequence...................................................................89
Dropping a Sequence.................................................................89
Using Indexes in Greenplum Database ............................................89
Index Types...............................................................................91
Creating an Index......................................................................92
Examining Index Usage .............................................................92
Managing Indexes .....................................................................93
Dropping an Index.....................................................................94
Creating and Managing Views..........................................................94
Creating Views...........................................................................94
Dropping Views..........................................................................94
Chapter 10: Managing Data.........................................................96
About Concurrency Control in Greenplum Database ........................96
Inserting New Rows ........................................................................97
Updating Existing Rows ...................................................................98
Deleting Rows .................................................................................98
Truncating a Table .....................................................................99
Working With Transactions..............................................................99
Transaction Isolation Levels.......................................................99
Vacuuming the Database ..............................................................101
Configuring the Free Space Map .............................................. 101
Chapter 11: Querying Data ........................................................102
Defining Queries ...........................................................................102
SQL Lexicon.............................................................................102
SQL Value Expressions ............................................................ 102
Using Functions and Operators......................................................111
Using Functions in Greenplum Database ..................................111
User-Defined Functions............................................................ 112
Built-in Functions and Operators..............................................112
Query Profiling ..............................................................................119
Reading EXPLAIN Output ......................................................... 120
Table of Contents v
Greenplum Database Administrator Guide 4.0 - Contents
Reading EXPLAIN ANALYZE Output ..........................................121
What to Look for in a Query Plan .............................................122
Chapter 12: Loading and Unloading Data ..............................124
About the Greenplum Database Loading Tools ..............................124
About External Tables..............................................................124
About gpload ...........................................................................125
About COPY .............................................................................125
Formatting Your Data Files............................................................125
Formatting Rows......................................................................125
Formatting Columns ................................................................126
Representing NULL Values .......................................................126
Escaping .................................................................................. 126
Character Encoding.................................................................. 127
Loading Data into Greenplum Database ........................................ 128
Creating and Using File-Based External Tables.........................128
Creating and Using Web External Tables..................................132
Loading Data Using an External Table......................................133
Handling Load Errors ...............................................................133
Loading Data with gpload ........................................................136
Loading Data with COPY .......................................................... 137
Data Loading Performance Tips ...............................................138
Unloading Data from Greenplum Database....................................138
Defining a File-Based Writable External Table ..........................138
Defining a Command-Based Writable External Table................ 139
Unloading Data Using a Writable External Table ...................... 139
Unloading Data Using COPY .....................................................140
Section IV: System Administration
Chapter 13: Starting and Stopping Greenplum .................... 142
Overview.......................................................................................142
Starting Greenplum Database .......................................................142
Restarting Greenplum Database ..............................................142
Uploading Configuration File Changes Only..............................143
Starting the Master in Maintenance Mode ................................143
Stopping Greenplum Database ......................................................143
Chapter 14: Configuring Your Greenplum System .............. 145
About Greenplum Master, Global, and Local Parameters ...............145
Setting Configuration Parameters..................................................145
Setting a Local Configuration Parameter ..................................146
Setting a Global or Master Configuration Parameter ................ 146
Viewing Settings of Server Configuration Parameters ...................147
Configuration Parameter Categories ..............................................147
Connection and Authentication Parameters..............................148
System Resource Consumption Parameters .............................149
Query Tuning Parameters ........................................................150
Error Reporting and Logging Parameters .................................152
System Monitoring Parameters ................................................152
Runtime Statistics Collection Parameters ................................. 153
剩余972页未读,继续阅读
王小燮
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
- 1
- 2
前往页