Documentation
Rate This Document
Findability
Accuracy
Completeness
Readability
SubmitClose

Overview

This document describes how to install Greenplum and KAEzip on a Kunpeng server running CentOS or openEuler. This document also describes how to enable KAEzip to improve the query performance in the OLAP scenario for the database, and how to rectify faults that may occur during the running of SQL statements in Greenplum.

  • Greenplum is a PostgreSQL-based distributed database. It uses the shared-nothing architecture to implement the massively parallel processing (MPP) architecture with high performance. It is a logical database consisting of multiple independent database services and can implement the functions of a relational database cluster. In this document, Greenplum 6.0.0 is used as an example.

    Figure 1 shows the Greenplum cluster architecture.

    Figure 1 Greenplum cluster architecture
  • KAEzip is the compression module of the Kunpeng Accelerator Engine (KAE). KAEzip uses the Kunpeng hardware acceleration module to implement the Deflate algorithm and works with the lossless user-mode driver framework to provide an interface for high-performance compression in gzip or zlib format. In this deployment, the version of KAE-kae1_zip_process-level-init is used as an example.
    • Supported data format: zlib or gzip, which complies with the RFC1950/RFC1952 standard
    • Supported algorithm: Deflate
    • Supported mode: synchronous
    • Maximum compression bandwidth of a single Kunpeng 920 processor: 7 GB/s; maximum decompression bandwidth of a single Kunpeng 920 processor: 8 GB/s
    • Supported compression ratio: approximately equal to 2, which is the same as that of the zlib 1.2.11 interface.
    Figure 2 shows the logical architecture of KAE.
    Figure 2 KAE logical architecture

    For more details, see Kunpeng Accelerator Engine Developer Guide (KAEzip).

Before KAEzip is enabled, Greenplum invokes the zlib interface by default. After KAEzip is enabled, Greenplum invokes the KAEzip interface because the function names of the KAEzip interface and zlib interface are the same. The hardware acceleration module in KAEzip accelerates the decompression speed during the query in the OLAP scenario for the database. In scenarios where one request is processed at a time and the I/O ratio is high, the end-to-end performance is significantly improved by 10%.