AnalyticDB for PostgreSQL  Play Video

A cloud-native real-time data warehouse service with ACID guarantees, compatible with the syntax of Greenplum, Oracle, and PostgreSQL, supporting high-performance low-latency ad hoc analysis of structured, unstructured, and semi-structured data; supporting vector data processing, seamlessly integrating large models, and providing enterprise-level vector database services for generative AI scenarios.

Deploy Domain-Specific ChatBot in One Click

AnalyticDB for PostgreSQL is an online MPP (Massively Parallel Processing) data warehousing service based on the open source Greenplum database.

AnalyticDB for PostgreSQL provides online expansion and performance monitoring service to free your team from complicated MPP cluster operations and management (O&M). This enables database administrators, developers and data analysis to focus on upgrading enterprise productivity through SQL development. And it benefits you from elasticity and cost-effectiveness by offering the Serverless edition >.

Based on MPP architecture, AnalyticDB for PostgreSQL also provides the vector database feature > to help you store, analyze, and retrieve vector data. AnalyticDB for PostgreSQL is selected as one of recommended vector databases by ChatGPT Retrieval Plugin > to help developers build generative-AI applications (see examples in OpenAI cookbook >) .

Popular Scenarios

Explore more >

Selected

Build Gen AI ChatBot

ECS + PAI-EAS (LLM) + AnalyticDB for PostgreSQL (Vector Database), view best practice >

  • One-click deployment, build in 7 minutes
  • Easy to use
  • Easy to scale at demand
  • Easy to manage

Popular Large Language Models

Llama 2 | ChatGLM-6B | Qwen

Deploy Now

AnalyticDB for PostgreSQL TPC-H Quick Benchmark

Effortlessly benchmark with TPC-H on AnalyticDB for PostgreSQL. Learn more >

  • Rapid Deployment
  • User-Friendly
  • Effortless Management

Product Used

ECS | AnalyticDB for PostgreSQL | OSS

Deploy Now

Benefits

Superior Performance
ApsaraDB AnalyticDB for PostgreSQL enables mixed use of row and column stores. Column stores are 100 times faster than OLAP analytics between row stores.
Supports high-performance parallel data imports into OSS, eliminating the bottleneck of single-channel imports.
Easy-to-Use
Supports rich OLAP SQL syntax and functions, as well as numerous Oracle functions. Industry-popular BI software can be unrolled for AnalyticDB for PostgreSQL directly.
Link ApsaraDB AnalyticDB for PostgreSQL with ApsaraDB for RDS to offer OLTP+OLAP (HTAP) hybrid transaction analytics solutions.
Stable and Reliable
Supports distributed database ACID transactions where all data is synchronized into two copies on two nodes. Also features distributed deployment with ternary protection of the segment, server and cabinet, safeguarding security of the data infrastructure.
Features distributed deployment with ternary protection of the segment, server and cabinet, safeguarding security of important data infrastructure.
Flexible Scalability
Scale the computing unit (CPU, memory, and storage space) and increase the OLAP performance to handle hundreds of terabytes.
Supports transparent OSS data operations. Cold data of non-online analytics can be stored in OSS with the storage capacity being scaled as needed. By incorporating data compression based on External Tables this solution greatly reduces production costs.

Features

  • Distributed

    Distributed database on ACID.


    Based on distributed MPP (Massively Parallel Processing) architecture.


    Storage and computing capabilities capable of linear expansion with increase of segments.


    Realizes full potential of OLAP computing efficiency.


    Distributed SQL OLAP statistics and window functions.


    PL/pgSQL and PL/JAVA stored procedures.

  • Machine Learning and Analysis

    MADlib machine learning base on SQL.


    Accords with international OpenGIS standards in its geographic data hybrid analysis.


    JSON data type analysis.


    HyperLogLog algorithm analysis.

  • Data Integration

    Supported by popular ETL tools with base on PostgreSQL/Greenplum JDBC drive.


    MySQL users can be incremental synchronization data with 'rds_dbsync'.


    Data queries in standard SQL syntax base on OSS External Table.


    OSS External Table supports data compression to reduce production costs.

  • Security

    A maximum of 1,000 server IP addresses are allowed in IP whitelist configuration.


    Real-time monitoring at the network access to active DDoS attacks.

  • Hybrid Analytics

    Supports real-time analytics on GIS data in SQL syntax to assist in LBS statistics for IoT devices and other Internet-based statistics.


    Supports real-time analytics on JSON, XML and fuzzy strings data in SQL syntax to help financial and government organizations, and enterprises achieve message data processing and fuzzy text matching.

AnalyticDB for PostgreSQL SQL Tuning Guide

As a cloud-native PB-level data warehousing service, AnalyticDB for PostgreSQL is a genius creation for MPP scenario with outstanding scalability.

This document highlights the key features of AnalyticDB for PostgreSQL and delves into the key points of SQL performance tuning, including table structure design in the early stage, analysis of slow SQL statements in use, and the practices for keeping the database in optimal condition during daily operations and maintenance.

Powering Generative AI Development with Vector Data Management

This whitepaper explains why vector data management is important to Gen AI development. It introduces Alibaba Cloud’s vector database, AnalyticDB for PostgreSQL, and supportive products for Gen AI. This whitepaper provides multiple solutions to quickly set up a Gen AI chatbot on Alibaba Cloud using these products, with step-to-step tutorials.

How it works

  • One-time Development
  • IoT Analytics (JSON+GIS)
  • Internet Approximating (HyperLogLog)
  • OLTP & OLAP
One-time Development

One-time Development

ISVs (Independent Software Vendor) can switch between MPP system applications in the on-premise and cloud environments. Businesses with on-premise infrastructure can leverage Greenplum Database directly, while businesses on the cloud can adopt AnalyticDB directly.

Developers only need to program the application once and the application will be able to run on both traditional and cloud platforms. At the same time, on-premise and cloud schemas are both connectable through PostgreSQL generic drivers, facilitating business communication with more platforms of the same architecture. You can easily build an integrated “hybrid cloud” data warehouse development platform without worrying about the differences between on-premise and cloud platforms.

IoT Analytics (JSON+GIS)

IoT Analytics (JSON+GIS)

ApsaraDB AnalyticDB and PostgreSQL are both nested with the OpenGIS-complying spatial database engine PostGIS for real-time positioning and route planning. PostGIS is supported by ArcGIS, Intergraph and QGIS. You can use simple SQL statements in the application in combination with GIS functions to handle complicated spatial geographical data models (2D and 3D processing supported).

Thanks to Hybrid’s comprehensive data OLAP capability, massive data analytics based on geographic information can be performed to provide decision-making support for IoT, mobile Internet, logistic delivery, smart cities, LBS, O2O business systems, and more.

Internet Approximating (HyperLogLog)

Internet Approximating (HyperLogLog)

Cardinality estimation is the most common application for Big Data scenarios. Memory demand, post-merging and processing data is major problems that arise during cardinality estimation. Page PV and VU calculations both fall into this demand category.

In SQL, we usually conduct the calculation using COUNT DISTINCT, but performance is low. HyperLogLog improves the query performance of cardinality estimation by 20 to 100 times, with an error rate of approximately 2%. HyperLogLog can be adopted in business scenarios that do not demand precise calculation accuracy. This greatly reduces server computation load and costs.

OLTP & OLAP

OLTP & OLAP

A wide range of options are available to import your Greenplum-based data warehouses to ApsaraDB AnalyticDB. You also don’t need to worry about the complicated O&M for the MPP cluster. At the same time, Alibaba Cloud provides you with a complete set of scaling and availability solutions to enable database administrators, developers and data analysts to focus on upgrading enterprise productivity through SQL and create core value.

With Alibaba Cloud ApsaraDB for RDS, you can realize the high-performance of OLTP applications. RDS supports MySQL, SQL Server and PostgreSQL. In combination with ApsaraDB AnalyticDB, you are able to integrate OLTP and OLAP databases on the cloud to establish a database architecture platform, including high-concurrency production transactions and decision-making analysis.

RAG Solution - AnalyticDB x Gen-AI - Vector Database Solution

LLM + VectorDB with Alibaba Cloud Is Customizable and Cost-Efficient

This blog explains the benefits of LLM + VectorDB with Alibaba Cloud (with examples).


We recommend using ECS for the backend and front end. If you will use open-source, the LLM (Large Language Model) can be used GPU-ECS or Platform for AI (Artificial Intelligence).

This tutorial will cover the entire infrastructure and retriever besides the LLM part. Learn More

Related Resources

Best Practices

How to Do Data Sharing Between Two AnalyticDB for PostgreSQL Instances

Best Practices

Power Gen-AI Apps With Cloud-Native Data Warehouse on Alibaba Cloud | AnalyticDB for PostgreSQL

Best Practices

How To | Prepare for the AnalyticDB for PostgreSQL TPC-H Benchmarking Test

View All

Practice

Create a Chatbot with LLM and AnalyticDB for PostgreSQL on Alibaba Cloud Using Terraform

This blog introduces how to provision resources by Terraform and explains the steps to build a ChatBot.

Practice

[Best Practice] Instance Plan Management Released by AnalyticDB for PostgreSQL

This article introduces the plan management function of AnalyticDB for PostgreSQL, as well as its implementation mechanism and best practices.

Practice

[Best Practice] Instance Pause Released by AnalyticDB for PostgreSQL to Help Optimize Costs

This article introduces the pause feature of AnalyticDB for PostgreSQL, as well as its implementation mechanism and best practice.

View All

Getting Started

AnalyticDB for PostgreSQL SQL Tuning Guide

This document highlights the key features of AnalyticDB for PostgreSQL and delves into the key points of SQL performance tuning.

View All

Rely on Alibaba Cloud's Worldwide Data Centers

Alibaba Cloud has 87 zones strategically located across 29 regions in the world, providing reliable computing support for billions of customers.

  • No.1

    Market Share in the Asia Pacific

    IaaS Market Share - Gartner IT Service Report 2022

  • 29

    Global Data Center regions
  • 3,200 +

    CDN Nodes Globally
  • 87

    Availability Zones

2

US East

2

US West

2

UK

3

Germany

3

Middle East

1

Thailand

2

Malaysia

3

Japan

1

South Korea

2

Australia(Closing Down)

3

China (Hong Kong)

22

China North

10

China South

2

China West

21

China East

3

Singapore

3

Indonesia

1

Philippines

1

Central China

Data centers and availability zones

Special Offer Terms & Conditions

The offers detailed on this page are of a limited time and are valid for as long as the page shows. The offers apply only to purchases of the specific products listed on this page from Alibaba Cloud. They do not apply to purchases made at third-party resellers.

Disclaimer

These are the terms and conditions that apply to promotions on alibabacloud.com, including ones where you must select products as part of the offer. No alternative terms and conditions apply.
• Alibaba Cloud reserves the right to modify or cancel the offer at any time.
• These offers only apply to products and digital content.
• These offers are limited to one per customer and account. If you have multiple accounts, only one account is eligible to participate.
• Only users that have passed our Real Name Registration verification process are eligible to participate.
• First instance promotion is applicable only to users who have never bought an instance under the same product. Please note that in this offer, PolarDB for MySQL, PostgreSQL, and Oracle are all categorized under the same product. Therefore, a user can only enjoy the promotion for only one of the following PolarDB databases: MySQL, PostgreSQL, or Oracle, and only if the user has not bought any instances under the PolarDB family.
• A user is eligible no more to purchase subscription instances with the promotion after buying first instance under the same product.
• Each of these offers may not be combined with other offers.
• Each of these offers are non-transferrable and may not be resold.
• Discounts and promotions will apply automatically when you check out if all terms and conditions have been met.
• If you violate any of the offer terms, the offer will be made invalid.

Show more

FAQs

1. How can I select the RDS, AnalyticDB for PostgreSQL and E-MapReduce?

AnalyticDB for PostgreSQL RDS E-MapReduce
Based on Greenplum Database OLAP (On-line Analytical Processing) Data Warehouse Scale-out storage as needed. MPP distributed architecture analytics and storage performances follow a linear increase curve. Complicated SQL queries can be resolved within seconds or even milliseconds, with concurrency controlled within 500.
MySQL / PostgreSQL / SQL Server OLTP (On-line Transaction Processing) database They support different database engines and target transaction-based real-time business model processing - CRUD (create, retrieve, update, and delete). Online data less than 2TB is supported.
Hadoop, Apache Spark, HBase, Presto, and Storm Big Data processing solution to quickly process a huge amount of data Allows you to quickly launch Hadoop clusters within minutes for massive data processing. This way, it simplifies complex big data processing by performing data-intensive tasks for applications involved.

2. Which ETL tools support ApsaraDB AnalyticDB for PostgreSQL?

AnalyticDB for PostgreSQL is based on the open-source Greenplum Database program and adopts universal JDBC and ODBC interfaces. Therefore, almost all ETL tools that support Greenplum and PostgreSQL also support AnalyticDB for PostgreSQL.

3. What is the difference between AnalyticDB for PostgreSQL and Greenplum Database on which AnalyticDB is based?

• AnalyticDB for PostgreSQL extensions support JSON, HyperLogLog and oss_ext external tables, while the open-source Greenplum Database doesn’t.

• AnalyticDB for PostgreSQL is a cloud computing service and configuration is made easy with the click of a mouse with the Alibaba Cloud Console. Users don’t have to worry about the management of data warehouse deployment and expansion, among other complicated configurations.

• AnalyticDB for PostgreSQL is structured on the unified management platform of Alibaba Cloud ApsaraDB and imposes limits on the superuser permissions.

4. Is the instance space purchased for AnalyticDB for PostgreSQL fully available for use?

The instance space is the truly usable space. AnalyticDB for PostgreSQL reserves an additional temporary file space which will not occupy the resources you have purchased.

5. What is the relationship between the AnalyticDB for PostgreSQL node type and the Greenplum Database segment?

• A node is composed of one or more segments. The cores, memory and disk space in the node type indicate the truly usable space. Taking a node type of 4 Cores/32GB Mem/2TB HDD for example, this node will contain: 4 segments that has 1 Core/8GB Mem/0.5TB HDD each.

• As an example, for a node type of 4 Cores/32GB Mem/2TB HDD, the corresponding native Greenplum Database contains a primary segment that totals 4 Cores/32GB Mem/2TB HDD, and a mirror segment that has 4 Cores/32GB Mem/2TB HDD. In other words, if you want to build a Greenplum Database cluster of the same configuration, you can prepare physical resources of 8 Cores/64GB Mem/4TB HDD or more (and the additional temporary file space for the cluster).

• All the segments in a node are allocated on the same server. A highly-configured node is conducive to reducing network switching and improving performance. We recommend you to choose a high-configuration node if you require more computing resources. To purchase a super-high configuration node, please contact your customer manager or apply by submitting a “ticket”.

6. How large can the storage capacity of AnalyticDB for PostgreSQL be scaled to?

We offer 2048 Cores/16TB Mem/1024TB HDD or higher configuration of computing and storage resources as per your requirements. To purchase a super-high configuration node, please contact your customer manager or apply by submitting a “Ticket” with the Console.

Upgraded Support For You

1 on 1 Presale Consultation, 24/7 Technical Support, Faster Response, and More Free Tickets.

1 on 1 Presale Consultation

Consulting by experienced cloud experts.Learn More

24/7 Technical Support

Extended service time from 10 hours 5 days a week to 24/7. Learn More

6 Free Tickets per Quarter

The number of free tickets doubled from 3 to 6 per quarter. Learn More

Faster Response

Shorten after-sale response time from 36 hours to 18 hours. Learn More
phone Contact Us