VMware Greenplum v6.18 Documentation

• 语言: 英语
• 格式: .pdf
• 来源: docs.vmware.com

摘要

文档主要介绍了VMware Tanzu Greenplum Database v6.18的发布内容，包括新功能、已解决的问题以及安装和升级指南。新功能涵盖了PostgreSQL核心特性的增强，如Zstandard压缩算法、放松指定表分布列的规则、复制表数据、资源组功能、PL/pgSQL存储过程语言的改进以及并发性提升。文档还提到了如何在不同操作系统和硬件上安装和配置Greenplum Database，以及性能管理和优化的建议。

AI总结

### VMware Greenplum v6.18 Documentation Summary

#### 1. **Version Releases and Features**
- **Release 6.18**:
- **New Features**:
- Zstandard Compression Algorithm
- Relaxed Rules for Specifying Table Distribution Columns
- Replicated Table Data
- PL/pgSQL Procedural Language Enhancements
- Concurrency Improvements in Greenplum 6
- Additional Contrib Modules
- PXF Version 5.8.1
- **Resolved Issues**: Includes fixes for cluster management, query planner, and server-related issues.

- **Release 6.18.1**:
- **Resolved Issues**: Addresses specific issues in cluster management, query optimizer, and server performance.

- **Release 6.18.0**:
- **Features**: Includes updates to the query optimizer, data loading, and cluster management.

- **Earlier Releases (6.17, 6.16, etc.)**:
- Each release includes specific features, resolved issues, and improvements in areas like query optimization, data loading, and cluster management.

#### 2. **Key Features**
- **PostgreSQL Core Features**:
- INTERVAL Data Type Handling (SQL standard alignment).
- **Resource Groups and Concurrency**:
- PL/pgSQL enhancements for better procedural language support.
- Improved concurrency control in Greenplum 6.
- **PXF (Plugin for External Data Formats)**:
- Updated to version 5.8.1, supporting additional data connectors.
- **Storage and Performance**:
- Zstandard compression for efficient data storage.
- Relaxed rules for table distribution columns.

#### 3. **Installation and Upgrading**
- **Platform Requirements**:
- Operating Systems: Red Hat Enterprise Linux 8.x, CentOS 7.x/8.x, Ubuntu 18.04/20.04.
- Hardware and Network: Specific configurations for Dell EMC VxRail systems.
- Storage: Recommendations for data domain boost and disk layout.
- **Upgrade Process**:
- Steps for upgrading from earlier versions (e.g., 6.x to newer 6.x releases).
- Backup and restore procedures for database migration.

#### 4. **Performance Management**
- **Query Performance**:
- Tools like EXPLAIN and EXPLAIN ANALYZE for query optimization.
- Managing spill files and query profiling.
- **Database Maintenance**:
- Vacuuming, lock management, and performance tuning.
- **Performance Factors**:
- Understanding factors like query execution, indexing, and resource allocation.

#### 5. **Transaction and Concurrency Control**
- **Transaction Isolation Levels**:
- Read Uncommitted, Read Committed, Repeatable Read, Serializable.
- **Concurrency Control**:
- Global deadlock detection and handling.
- **Deadlock Detection**:
- Compatibility between UPDATE and DELETE operations.

#### 6. **Security and Network**
- **iptables (Optional)**:
- Example rules for enabling iptables on master, standby master, and segment hosts.

#### 7. **Environment Variables**
- **Required Variables**:
- `GPHOME`, `PATH`, `LD_LIBRARY_PATH`, `MASTER_DATA_DIRECTORY`.
- **Optional Variables**: Additional environment variables for specific configurations.

#### 8. **Known Issues and Limitations**
- Specific to VMware Tanzu Greenplum 6.18, with details on ongoing limitations.

#### 9. **Support and Compatibility**
- **Related Products**: Compatibility with Tanzu Greenplum tools, extensions, and data connectors.
- **Hardware and Software**: Platform requirements and dependencies for optimal performance.

This summary provides a concise overview of the key features, updates, and guidelines for working with VMware Greenplum v6.18, focusing on core functionalities and practical implementation details.