All Products
Document Center

AnalyticDB for PostgreSQL:Overview

Last Updated:Apr 15, 2024

AnalyticDB for PostgreSQL is a massively parallel processing (MPP) data warehousing service that is designed to analyze large volumes of data online.

AnalyticDB for PostgreSQL is developed based on the open source Greenplum Database project and is enhanced with in-depth extensions by Alibaba Cloud. AnalyticDB for PostgreSQL is compatible with the ANSI SQL 2003 syntax and the PostgreSQL and Oracle database ecosystems. AnalyticDB for PostgreSQL also supports row store and column store. AnalyticDB for PostgreSQL processes petabytes of data offline at a high performance level and supports highly concurrent online queries. This way, AnalyticDB for PostgreSQL can provide a competitive data warehousing solution for various industries.


  • Adaptable to variable workloads without optimization required.

    AnalyticDB for PostgreSQL is fully compatible with SQL 2003 syntax and partially compatible with Oracle syntax. This service also supports PL/SQL stored procedures. AnalyticDB for PostgreSQL offers next-generation query optimizers to eliminate the need to optimize complex SQL statements.

  • Analyzes petabytes of data within seconds.

    AnalyticDB for PostgreSQL uses an MPP scale-out architecture to respond to queries for petabytes of data within seconds. AnalyticDB for PostgreSQL supports vector computing and intelligent column store indexing. The performance of AnalyticDB for PostgreSQL is approximately 10 times better than that of a traditional database engine.

  • Provides high availability and always-on connectivity.

    AnalyticDB for PostgreSQL supports distributed transactions, redundancy for all nodes and data, automatic monitoring and failover for hardware faults, and atomicity, consistency, isolation, durability (ACID).

  • Compatible with various ecosystems.

    AnalyticDB for PostgreSQL supports mainstream business intelligence (BI) and extract, transform, and load (ETL) tools. For example, AnalyticDB for PostgreSQL is integrated with the PostGIS extension to analyze geographic data and with the MADlib library to provide more than 300 built-in machine learning algorithms.

  • Enables data synchronization.

    AnalyticDB for PostgreSQL can synchronize data from various data sources by using tools such as Data Transmission Service (DTS) and DataWorks. AnalyticDB for PostgreSQL supports highly parallel access to Object Storage Service (OSS) and Data Lake Analytics (DLA).

Service architecture

AnalyticDB for PostgreSQL uses the MPP architecture. In this architecture, an instance is composed of multiple compute nodes and uses a type of Enhanced SSD (ESSD) as the storage type. Computing is decoupled from storage. You can add compute nodes to an instance or scale up its storage capacity and maintain a stable response time. Each instance is composed of the following components:

  • Coordinator node

    • Receives query requests and determines distributed query plans.

  • Compute node

    • Provides MPP.

    • Stores data partitions on two compute nodes.

    • Automatically backs up data to OSS on a regular basis.



AnalyticDB for PostgreSQL is developed based on the open source Greenplum Database project and is enhanced with in-depth extensions by Alibaba Cloud. In AnalyticDB for PostgreSQL, some features of Greenplum Database such as triggers are prohibited based on the in-depth understanding and maintenance experience of the AnalyticDB for PostgreSQL team on Greenplum Database. For more information about the limits of AnalyticDB for PostgreSQL, see Limits.