2023

Feature

Description

Related documentation

External data source management (Public Preview)

You can map heterogeneous external data sources to a foreign table, allowing you to run parallel, high-throughput federated queries on data from external sources.

• Access heterogeneous data sources

• Access homogeneous data sources

Real-time analytics (Public Preview)

The real-time analytics feature includes a high-speed data import API and real-time data source integration. You can write data directly to a segment to avoid the high write loads that COPY or INSERT operations can place on the coordinator node. You can also use a single AnalyticDB for PostgreSQL instance to directly consume data from Kafka.

Overview of real-time data consumption

Feature

Description

Related documentation

Active queries

AnalyticDB for PostgreSQL now supports active queries. The system automatically collects and displays active queries every 5 seconds. You can cancel blocked queries or terminate their sessions as needed.

Active queries

Feature

Description

Related documentation

Convert to pay-as-you-go

You can convert a AnalyticDB for PostgreSQL subscription instance to a pay-as-you-go instance. You can switch between the two billing methods.

Switch billing methods

Backup and restoration

AnalyticDB for PostgreSQL V7.0 now supports backup and restoration.

• Back up data

• Restore data

Manage coordinator node resources

In the adjusted resource model for AnalyticDB for PostgreSQL, coordinator nodes are measured in coordinator CUs (Compute Units), and more specifications are available.

• Create an instance

• Manage coordinator node resources

Tiered storage of hot and cold data

AnalyticDB for PostgreSQL supports tiered storage of hot and cold data. You can store data tables in Object Storage Service (OSS) to reduce storage costs.

Tiered storage of hot and cold data

Feature

Description

Related documentation

Vector engine optimization

AnalyticDB for PostgreSQL includes the vector engine optimization feature for vector analysis scenarios such as AIGC and vector search.

Enabling this feature optimizes system parameters for vector analysis. However, this feature consumes a large amount of memory and significantly reduces instance concurrency. Assess the potential impacts before you enable this feature.

This feature is available only for V6.0 instances in elastic storage mode with compute nodes of 4 cores/32 GB or higher specifications.

• Create an instance

• Enable or disable vector engine optimization

Feature

Description

Related documentation

Change the disk storage type

You can now change the disk storage type for instances in elastic storage mode.

Change the disk storage type

New disk storage types

To meet diverse storage performance and price requirements, AnalyticDB for PostgreSQL now supports the following disk types:

• ESSD PL0

• ESSD PL2

  Note

  • You can use ESSD PL2 only when the storage capacity per node is greater than 500 GB.

  • Ultra Disk is no longer available for new purchases.

• Change the disk storage type

• Create an instance

• Block storage performance

Feature

Description

Related documentation

New regions and zones for Basic Edition (formerly High-performance Edition) instances

Basic Edition instances of AnalyticDB for PostgreSQL in elastic storage mode are now available in the following regions and availability zones.

• China

  • China (Hong Kong) availability zone C

  • China (Zhangjiakou) availability zone B and availability zone C

  • China (Hohhot) availability zone A and availability zone B

• Asia Pacific

  • Japan (Tokyo) availability zone B

  • South Korea (Seoul) availability zone A

  • Malaysia (Kuala Lumpur) availability zone A

• Europe and Americas

  • Germany (Frankfurt) availability zone A

  • UK (London) availability zone A

  • US (Virginia) availability zone A and availability zone B

  • US (Silicon Valley) availability zone A

• Basic Edition instances

• Create an instance

Feature

Description

Related documentation

Manually pause and resume an instance

You can now pause and resume AnalyticDB for PostgreSQL pay-as-you-go instances in elastic storage mode. When an instance is paused, you are charged for storage resources but not for computing resources.

Manually pause and resume an instance

Manage plans

For AnalyticDB for PostgreSQL pay-as-you-go instances in elastic storage mode, use the plan management feature to schedule Pause and Resume Instance operations and Change Specifications. This lets you customize resource plans based on a time schedule.

Manage plans

Automatic scheduling mode for Serverless mode

AnalyticDB for PostgreSQL in Serverless mode now includes the automatic scheduling mode. Instances in this mode automatically pause and resume based on traffic detection. If an instance has no traffic, it enters an idle state, and you are not charged for computing resources.

• Create an instance

• Configure instance resources