AnalyticDB for PostgreSQL is a massively parallel processing (MPP) data warehouse service that is compatible with the ANSI SQL 2003 syntax and the PostgreSQL and Oracle database ecosystems. AnalyticDB for PostgreSQL provides comprehensive transaction processing capabilities, high-throughput writes, and a unified batch and streaming processing engine. AnalyticDB for PostgreSQL uses hybrid row-column storage and the compute engine developed in-house by Alibaba Cloud to implement high-performance data processing and real-time analysis. The self-developed enterprise-class features of AnalyticDB for PostgreSQL, especially in aspects such as security enhancement, data integration, resource isolation, tiered storage of hot and cold data, and high availability, are widely used in a variety of industries. AnalyticDB for PostgreSQL can help enterprises build data analysis platforms that integrate batch processing and real-time analysis or streaming processing. A single engine can be used to meet all requirements for batch processing, stream computing, and interactive analysis. AnalyticDB for PostgreSQL provides AI-powered data warehouses and uses solutions, such as vector search, one-stop Retrieval-Augmented Generation (RAG) service, enterprise knowledge bases, text-based image search, and image-based image search, to help enterprises quickly build AI applications and enable integrated data and AI capabilities.
Architecture
AnalyticDB for PostgreSQL is available in elastic storage mode and Serverless mode. The elastic storage mode uses a shared-nothing architecture based on Elastic Compute Service (ECS) and Enterprise SSDs (ESSDs) and provides MPP capabilities. The Serverless mode uses a shared-storage architecture based on ECS, local cache, and Object Storage Service (OSS) and provides decoupled storage and computing capabilities.
An AnalyticDB for PostgreSQL instance consists of a coordinator node and multiple compute nodes. The coordinator node is responsible for metadata management and load balancing. The compute nodes are responsible for data processing. The compute nodes integrate the Orca optimizer and the self-developed Laser execution engine and Beam storage engine to implement high-performance queries. The compute nodes also use incremental materialized views (IMVs) to build real-time materialized views. AnalyticDB for PostgreSQL stores hot data on ESSDs attached to the compute nodes and cold data in OSS. The tiered storage of hot and cold data helps improve query performance and reduce storage costs. You can separately scale the computing and storage resources of the compute nodes.
Features
Adaptable to variable workloads without the need for optimization.
AnalyticDB for PostgreSQL is fully compatible with the SQL 2003 syntax and partially compatible with the Oracle syntax. AnalyticDB for PostgreSQL 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 higher than the performance 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, load (ETL) tools. For example, AnalyticDB for PostgreSQL is integrated with the PostGIS extension to analyze geographic data and the MADlib library to provide more than 300 built-in machine learning algorithms.
Enables data synchronization.
AnalyticDB for PostgreSQL can perform real time data synchronization and batch data import from various data sources by using tools such as Data Transmission Service (DTS) and DataWorks. AnalyticDB for PostgreSQL supports high-concurrency access to OSS and data lake analysis.
Technical support
For technical support, join the AnalyticDB for PostgreSQL DingTalk group 11700737.
Limits
For information about the limits of AnalyticDB for PostgreSQL, see Limits.