OS Resource Parameters
A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 5.x documentation.
OS Resource Parameters
- max_files_per_process
- shared_preload_libraries
Doc Index
- Greenplum Database 5.8 Documentation
-
Administrator Guide
- Greenplum Database Concepts
-
Managing a Greenplum System
- About the Greenplum Database Release Version Number
- Starting and Stopping Greenplum Database
- Accessing the Database
-
Configuring the Greenplum Database System
- About Greenplum Database Master and Local Parameters
- Setting Configuration Parameters
- Viewing Server Configuration Parameter Settings
-
Configuration Parameter Categories
- Connection and Authentication Parameters
- System Resource Consumption Parameters
-
Query Tuning Parameters
- GPORCA Configuration Parameters
- Query Plan Operator Control Parameters
- Legacy Query Optimizer Costing Parameters
- Database Statistics Sampling Parameters
- Sort Operator Configuration Parameters
- Aggregate Operator Configuration Parameters
- Join Operator Configuration Parameters
- Other Legacy Query Optimizer Configuration Parameters
- Error Reporting and Logging Parameters
- System Monitoring Parameters
- Runtime Statistics Collection Parameters
- Automatic Statistics Collection Parameters
- Client Connection Default Parameters
- Lock Management Parameters
- Resource Management Parameters
- External Table Parameters
- Database Table Parameters
- Database and Tablespace/Filespace Parameters
- Past Version Compatibility Parameters
- Greenplum Array Configuration Parameters
- Greenplum Master and Segment Mirroring Parameters
- Greenplum Database Extension Parameters
- Enabling High Availability and Data Consistency Features
-
Backing Up and Restoring Databases
- Backup and Restore Overview
-
Parallel Backup with gpcrondump and gpdbrestore
- Backup and Restore Options
- Backing Up with gpcrondump
- Backing Up a Set of Tables
- Creating Incremental Backups
- Backup Process and Locks
- Using Direct I/O
- Using Named Pipes
- Backing Up Databases with Data Domain Boost
- Backing Up Databases with Veritas NetBackup
- Restoring Greenplum Databases
- Restoring a Database Using gpdbrestore
- Restoring to a Different Greenplum System Configuration
-
Parallel Backup with gpbackup and gprestore
- Requirements and Limitations
- Objects Included in a Backup or Restore
- Performing Basic Backup and Restore Operations
- Filtering the Contents of a Backup or Restore
- Configuring Email Notifications
- Understanding Backup Files
- Using gpbackup and gprestore with BoostFS
- Using the S3 Storage Plugin with gpbackup and gprestore
- Backup/Restore Storage Plugin API
- Expanding a Greenplum System
- Migrating Data with gptransfer
- Monitoring a Greenplum System
- Routine System Maintenance Tasks
- Recommended Monitoring and Maintenance Tasks
- Managing Greenplum Database Access
- Defining Database Objects
- Distribution and Skew
- Inserting, Updating, and Deleting Data
- Querying Data
-
Working with External Data
-
Defining External Tables
- file:// Protocol
- gpfdist:// Protocol
- gpfdists:// Protocol
- gphdfs:// Protocol
- pxf:// Protocol
- s3:// Protocol
- Using a Custom Protocol
- Handling Errors in External Table Data
- Creating and Using External Web Tables
-
Examples for Creating External Tables
- Example 1—Single gpfdist instance on single-NIC machine
- Example 2—Multiple gpfdist instances
- Example 3—Multiple gpfdists instances
- Example 4—Single gpfdist instance with error logging
- Example 5—TEXT Format on a Hadoop Distributed File Server
- Example 6—Multiple files in CSV format with header rows
- Example 7—Readable External Web Table with Script
- Example 8—Writable External Table with gpfdist
- Example 9—Writable External Web Table with Script
- Example 10—Readable and Writable External Tables with XML Transformations
- Accessing External Data with PXF
-
Accessing HDFS Data with gphdfs
- One-time gphdfs Protocol Installation
- Grant Privileges for the gphdfs Protocol
- Specify gphdfs Protocol in an External Table Definition
- Support for Avro Files
- Support for Parquet Files
- HDFS Readable and Writable External Table Examples
- Reading and Writing Custom-Formatted HDFS Data
- Using Amazon EMR with Greenplum Database installed on AWS
- Using the Greenplum Parallel File Server (gpfdist)
-
Defining External Tables
-
Loading and Unloading Data
- Loading Data Using an External Table
- Loading and Writing Non-HDFS Custom Data
- Handling Load Errors
- Loading Data with gpload
- Transforming External Data with gpfdist and gpload
- Loading Data with COPY
- Running COPY in Single Row Error Isolation Mode
- Optimizing Data Load and Query Performance
- Unloading Data from Greenplum Database
- Formatting Data Files
- Example Custom Data Access Protocol
- Managing Performance