Skip to content
Greenplum Documentation
Greenplum 2026
Initializing search
Greenplum Documentation
Home
DR
DR
Gpdr
Gpdr
Описание
Установка конфигурации
RoadMap развития
RoadMap развития
Greenplum 2026
Greenplum 2026
Содержание
План развития функционала Greenplum на 2026 год
Дополнительно
Дополнительно
Парсер
Интеграция с CM
Интеграция с CM
Cm
Cm
Описание
Greenplum.metric.api
Greenplum.metric.api
Openapi
Описание
Установка
Greenplum.metric.monitor
Greenplum.metric.monitor
Openapi
Обновление
Описание
Сборка
Установка
Мониторинг запросов
Мониторинг запросов
Greenplum.metric.agent
Greenplum.metric.agent
Metricdb
Конфигурация
Описание
Сборка
Установка
Greenplum.metric.hook
Greenplum.metric.hook
Деинсталляция
Конфигурация
Информация о метриках
Описание
Сборка
Установка
Мониторинг кластера
Мониторинг кластера
Greenplum.monitoring
Greenplum.monitoring
Конфигурация
Обновление
Описание дашбордов
Описание релиза мониторинга
Описание
Установка
Официальная документация GP6
Официальная документация GP6
Официальная документация Greenplum 6
Administration
Administration
About the Greenplum Database Release Version Number
About Greenplum Database Master and Local Parameters
Accessing the Database
Backing Up and Restoring Databases
Best Practices Summary
Checking for Failed Segments
Common Causes of Performance Issues
Configuration Parameter Categories
Configuring Client Authentication
Configuring Kerberos For Windows Clients
Configuring Kerberos for Linux Clients
Configuring Proxies for the Greenplum Interconnect
Configuring the Greenplum Database System
Connecting with psql
Database Application Interfaces
Defining Database Performance
Distribution and Skew
Enabling Compression
Enabling High Availability and Data Consistency Features
Enabling Master Mirroring
Enabling Mirroring in Greenplum Database
Enabling Segment Mirroring
Encrypting Data and Database Connections
Establishing a Database Session
Expanding a Greenplum System
Greenplum Database Best Practices
Greenplum Database Client Applications
Greenplum Database Memory Overview
High Availability
How Greenplum Database Detects a Failed Segment
Identifying and Mitigating Heap Table Performance Issues
Initializing New Segments
Investigating a Performance Problem
Loading Data
Managing Bloat in a Database
Managing Greenplum Database Access
Managing Performance
Managing Resources
Managing Roles and Privileges
Memory and Resource Management with Resource Groups
Memory and Resource Management with Resource Queues
Migrating Data with gpcopy
Monitoring Greenplum Database Log Files
Monitoring a Greenplum System
Overview of Greenplum Database High Availability
Overview of Master Mirroring
Overview of Segment Mirroring
Planning Greenplum System Expansion
Post Expansion Tasks
Preparing and Adding Hosts
Recommended Monitoring and Maintenance Tasks
Recovering a Failed Master
Recovering from Segment Failures
Redistributing Tables
Restoring Master Mirroring After a Recovery
Routine System Maintenance Tasks
Schema Design
Security
Setting Configuration Parameters
Setting Parameters at the Database Level
Setting Parameters at the Role Level
Setting Parameters at the System Level
Setting Parameters in a Session
Setting a Local Configuration Parameter
Setting a Master Configuration Parameter
Starting and Stopping Greenplum Database
Supported Client Applications
System Configuration
System Expansion Overview
System Monitoring and Maintenance
Troubleshooting Connection Problems
Tuning SQL Queries
Understanding Segment Recovery
Updating Statistics with ANALYZE
Using Kerberos Authentication
Using LDAP Authentication with TLS/SSL
Using Resource Groups
Using Resource Queues
Using the PgBouncer Connection Pooler
Viewing Server Configuration Parameter Settings
Concepts
Concepts
Greenplum Database Concepts
About Concurrency Control in Greenplum Database
About Database Statistics in Greenplum Database
About Management and Monitoring Utilities
About Parallel Data Loading
About Redundancy and Failover in Greenplum Database
About the Greenplum Architecture
Example of Managing Transaction IDs
Managing Data
Managing Data
Managing Data
About Full Text Search
About GPORCA
About Greenplum Query Processing
About Uniform Multi-level Partitioned Tables
About View Storage in Greenplum Database
About the Tools Package
Accessing External Data with Foreign Tables
Accessing External Data with PXF
Activating and Deactivating GPORCA
Additional Text Search Features
Best Practices when Creating Views
Capture Row Formatting Errors and Declare a Reject Limit
Changed Behavior with GPORCA
Character Encoding
Choosing the Table Storage Model
Client and Loader Utility Reference
Collecting Root Partition Statistics
Configuring Greenplum Database for Remote Client Access
Configuring a Client System for Kerberos Authentication
Considerations when Using GPORCA
Controlling Text Search
Creating and Managing Databases
Creating and Managing Materialized Views
Creating and Managing Schemas
Creating and Managing Tables
Creating and Managing Tablespaces
Creating and Managing Views
Creating and Using External Web Tables
Creating and Using Sequences
Deactivating EXECUTE for Web or Writable External Tables
Define an External Table with Single Row Error Isolation
Defining Database Objects
Defining External Tables
Defining Queries
Defining a Command-Based Writable External Web Table
Defining a File-Based Writable External Table
Determining the Query Optimizer that is Used
Escaping in CSV Formatted Files
Escaping in Text Formatted Files
Escaping
Example 10—Readable and Writable External Tables with XML Transformations
Example 1—Greenplum file server (gpfdist)
Example 1—Single gpfdist instance on single-NIC machine
Example 2—Hadoop file server (pxf)
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 Custom Data Access Protocol
Examples for Creating External Tables
Examples of Reading Fixed-Width Data
Formatting Columns
Formatting Data Files
Formatting Rows
GPORCA Features and Enhancements
GPORCA Limitations
Geospatial Analytics
GiST and GIN Indexes for Text Search
Graph Analytics
Greenplum Client and Loader Tools Package
Greenplum Database R Client
Handling Errors in External Table Data
Handling Load Errors
Importing and Exporting Fixed Width Data
Inserting, Updating, and Deleting Data
Installing the Client and Loader Tools Package
Installing the External Table Protocol
Limitations
Loading Data Using an External Table
Loading Data with COPY
Loading Data with gpload
Loading and Unloading Data
Loading and Writing Non-HDFS Custom Data
Machine Learning and Deep Learning using MADlib
Managing Spill Files Generated by Queries
Managing a Greenplum System
Moving Data between Tables
Optimizing Data Load and Query Performance
Overview of GPORCA
Overview of Greenplum Database Integrated Analytics
PL/Container Language
PL/Java Language
PL/Perl Language
PL/Python Language
PL/R Language
PL/pgSQL Language
Partitioning Large Tables
Procedural Languages
Query Performance
Query Profiling
Querying Data
Representing NULL Values
Running COPY in Single Row Error Isolation Mode
Running the UNIX Tools Installer
Running the Windows Tools Installer
Searching Text in Database Tables
Testing and Debugging Text Search
Text Analytics and Search
Text Search Configuration Example
Text Search Dictionaries
Text Search Parsers
Transforming External Data with gpfdist and gpload
Unloading Data Using COPY
Unloading Data Using a Writable External Table
Unloading Data from Greenplum Database
Upgrading PostGIS 2.1.5 or 2.5.4
Using Full Text Search
Using Functions and Operators
Using Greenplum MapReduce
Using Indexes in Greenplum Database
Using PL/Container
Using a Custom Format
Using a Custom Protocol
Using the Client and Loader Tools
Using the Greenplum Parallel File Server (gpfdist)
Viewing Bad Rows in the Error Log
WITH Queries (Common Table Expressions)
Working with External Data
Working with JSON Data
Working with View Dependencies
Working with XML Data
Writing a Foreign Data Wrapper
createdb
createuser
dropdb
dropuser
file:// Protocol
gpextprotocal.c
gpfdist:// Protocol
gpfdist
gpfdists:// Protocol
gpload
pg_dump
pg_dumpall
psql Support
psql
pxf:// Protocol
s3:// Protocol
Reference Guide
Reference Guide
Greenplum Database Reference Guide
ABORT
ALTER AGGREGATE
ALTER COLLATION
ALTER CONVERSION
ALTER DATABASE
ALTER DEFAULT PRIVILEGES
ALTER DOMAIN
ALTER EXTENSION
ALTER EXTERNAL TABLE
ALTER FOREIGN DATA WRAPPER
ALTER FOREIGN TABLE
ALTER FUNCTION
ALTER GROUP
ALTER INDEX
ALTER LANGUAGE
ALTER MATERIALIZED VIEW
ALTER OPERATOR CLASS
ALTER OPERATOR FAMILY
ALTER OPERATOR
ALTER PROTOCOL
ALTER RESOURCE GROUP
ALTER RESOURCE QUEUE
ALTER ROLE
ALTER RULE
ALTER SCHEMA
ALTER SEQUENCE
ALTER SERVER
ALTER TABLE
ALTER TABLESPACE
ALTER TEXT SEARCH CONFIGURATION
ALTER TEXT SEARCH DICTIONARY
ALTER TEXT SEARCH PARSER
ALTER TEXT SEARCH TEMPLATE
ALTER TRIGGER
ALTER TYPE
ALTER USER MAPPING
ALTER USER
ALTER VIEW
ANALYZE
Additional Supplied Modules
BEGIN
CHECKPOINT
CLOSE
CLUSTER
COMMENT
COMMIT
COPY
CREATE AGGREGATE
CREATE CAST
CREATE COLLATION
CREATE CONVERSION
CREATE DATABASE
CREATE DOMAIN
CREATE EXTENSION
CREATE EXTERNAL TABLE
CREATE FOREIGN DATA WRAPPER
CREATE FOREIGN TABLE
CREATE FUNCTION
CREATE GROUP
CREATE INDEX
CREATE LANGUAGE
CREATE MATERIALIZED VIEW
CREATE OPERATOR CLASS
CREATE OPERATOR FAMILY
CREATE OPERATOR
CREATE PROTOCOL
CREATE RESOURCE GROUP
CREATE RESOURCE QUEUE
CREATE ROLE
CREATE RULE
CREATE SCHEMA
CREATE SEQUENCE
CREATE SERVER
CREATE TABLE AS
CREATE TABLE
CREATE TABLESPACE
CREATE TEXT SEARCH CONFIGURATION
CREATE TEXT SEARCH DICTIONARY
CREATE TEXT SEARCH PARSER
CREATE TEXT SEARCH TEMPLATE
CREATE TRIGGER
CREATE TYPE
CREATE USER MAPPING
CREATE USER
CREATE VIEW
Character Set Support
Configuration Parameters
DEALLOCATE
DECLARE
DELETE
DISCARD
DO
DROP AGGREGATE
DROP CAST
DROP COLLATION
DROP CONVERSION
DROP DATABASE
DROP DOMAIN
DROP EXTENSION
DROP EXTERNAL TABLE
DROP FOREIGN DATA WRAPPER
DROP FOREIGN TABLE
DROP FUNCTION
DROP GROUP
DROP INDEX
DROP LANGUAGE
DROP MATERIALIZED VIEW
DROP OPERATOR CLASS
DROP OPERATOR FAMILY
DROP OPERATOR
DROP OWNED
DROP PROTOCOL
DROP RESOURCE GROUP
DROP RESOURCE QUEUE
DROP ROLE
DROP RULE
DROP SCHEMA
DROP SEQUENCE
DROP SERVER
DROP TABLE
DROP TABLESPACE
DROP TEXT SEARCH CONFIGURATION
DROP TEXT SEARCH DICTIONARY
DROP TEXT SEARCH PARSER
DROP TEXT SEARCH TEMPLATE
DROP TRIGGER
DROP TYPE
DROP USER MAPPING
DROP USER
DROP VIEW
Data Types
Date/Time Types
END
EXECUTE
EXPLAIN
FETCH
GRANT
INSERT
LISTEN
LOAD
LOCK
MOVE
NOTIFY
PREPARE
Parameter Categories
Pseudo-Types
REASSIGN OWNED
REFRESH MATERIALIZED VIEW
REINDEX
RELEASE SAVEPOINT
RESET
RETRIEVE
REVOKE
ROLLBACK TO SAVEPOINT
ROLLBACK
Range Types
SAVEPOINT
SELECT INTO
SELECT
SET CONSTRAINTS
SET ROLE
SET SESSION AUTHORIZATION
SET TRANSACTION
SET
SHOW
SQL Commands
SQL Syntax Summary
START TRANSACTION
Server Configuration Parameters
Summary of Built-in Functions
TRUNCATE
Text Search Data Types
UNLISTEN
UPDATE
VACUUM
VALUES
advanced_password_check
auto_explain
btree_gin
citext
dblink
diskquota
fuzzystrmatch
gp_array_agg
gp_check_functions
gp_legacy_string_agg
gp_parallel_retrieve_cursor
gp_percentile_agg
gp_sparse_vector
greenplum_fdw
hstore
ip4r
isn
ltree
orafce
pageinspect
pg_trgm
pgaudit
pgcrypto
postgres_fdw
postgresql-hll
sslinfo
tablefunc
timestamp9
uuid-ossp
Utility Guide
Utility Guide
Greenplum Database Utility Guide
About the Greenplum Database Utilities
Utility Reference
analyzedb
clusterdb
createdb
createuser
dropdb
dropuser
gpactivatestandby
gpaddmirrors
gpcheckcat
gpcheckperf
gpconfig
gpcopy
gpdeletesystem
gpexpand
gpfdist
gpinitstandby
gpinitsystem
gpload
gplogfilter
gpmapreduce
gpmapreduce.yaml
gpmemreport
gpmemwatcher
gpmovemirrors
gpmt analyze_session
gpmt gp_log_collector
gpmt gpstatscheck
gpmt packcore
gpmt
gppkg
gprecoverseg
gpreload
gpscp
gpssh-exkeys
gpssh
gpstart
gpstate
gpstop
gpv base
gpv config
gpv greenplum
gpv
pg_config
pg_dump
pg_dumpall
pg_restore
pgbouncer-admin
pgbouncer.ini
pgbouncer
plcontainer Configuration File
plcontainer
psql
reindexdb
storage_rca_collector
vacuumdb
Плейбуки
Плейбуки
Описание
GP api
GP api
Описание
Установка
GP core
GP core
Описание
Траблшутинг
Установка
GP hooklib
GP hooklib
Описание
Установка
GP metr mon
GP metr mon
Описание
Установка
GP mntr
GP mntr
Описание
Установка
GP srvc
GP srvc
Описание
Установка
Сервисные задания
Сервисные задания
Greenplum.maintenance pack
Greenplum.maintenance pack
Деинсталляция
Конфигурация
Описание
Установка
Greenplum.tables audit
Greenplum.tables audit
Конфигурация
Описание
Установка
Ядро
Ядро
Возможности
Greenplum
Greenplum
Обновление
Описание
Установка
PXF
PXF
Возможности
Конфигурация
Обновление
Описание
Установка
Greenplum.clickhouse
Greenplum.clickhouse
Возможности
Использование
Конфигурация
Обновление
Описание
Установка
Greenplum.kafka
Greenplum.kafka
Возможности
Использование
Конфигурация
Обновление
Описание
Установка
Содержание
План развития функционала Greenplum на 2026 год
Greenplum 2026
План развития функционала Greenplum на 2026 год
