2021

Feature

Description

References

Serverless mode

AnalyticDB for PostgreSQL now supports Serverless mode, which separates computing and storage resources, enables elastic scaling within seconds, and allows real-time data sharing across instances. The feature is built on cloud infrastructure resource pooling and massive storage capabilities, combined with massively parallel processing (MPP), online and offline data processing, and Serverless technologies.

Serverless mode and Create an AnalyticDB for PostgreSQL instance

New zones for Basic Edition

Basic Edition instances are now available in the following zones: China (Hangzhou): Zone I, China (Shenzhen): Zone E, Singapore (Singapore): Zone A, and Indonesia (Jakarta): Zone A.

Basic Edition

Feature

Description

References

Instance data restoration across zones and editions

Instance data can now be restored across zones and editions, so you can change the zone and edition of an existing instance as your business grows or as new zones and services become available.

[Notice] Instance data restoration across zones and editions supported and Restore data

Compute node scale-down

Compute nodes can be scaled down to reduce costs during off-peak hours.

• [Notice] Compute node scale-down supported

• Change the specifications of compute nodes

Feature

Description

References

Diagnostics and optimization

The diagnostics and optimization feature is now available in the console. Use it to view slow queries and SQL distribution statistics within a specified time range.

[Notice] Diagnostics and optimization feature released, View slow SQL queries, and View SQL distribution statistics

Basic Edition

Basic Edition was released on September 29, 2021. It uses a single-replica architecture to lower storage costs for small and micro enterprises and individual users, and to reduce entry-level instance costs for large and medium-sized enterprises.

[Notice] AnalyticDB for PostgreSQL Basic Edition released, Basic Edition, and Create an AnalyticDB for PostgreSQL instance

Feature

Description

References

I/O performance

I/O performance of new instances created on May 19, 2021 or later is improved by 30% to 50%.

I/O performance optimization on compute nodes

Feature

Description

References

Point-in-time recovery (PITR)

PITR is now supported.

—

Multi-Master feature

When used with the compute node elasticity feature, the system's connection count and read/write capacity can scale linearly as the number of Master nodes increases.

Primary endpoint and cluster endpoint

Multi-replica

Two or more compute nodes can synchronize data.

—

Upgrade or downgrade across specifications

Clusters can be changed from reserved mode to elastic mode.

—

Indexes for JSON fields

Indexes for JSON fields can be created or deleted using ALTER TABLE statements, including the ability to disable indexes for JSON fields.

ALTER TABLE

BINARY type

The BINARY type is now supported for metadata of the protocol layer.

—

File header export to OSS

File headers can be exported when exporting data from AnalyticDB for PostgreSQL to a single OSS object using an external table.

Use an external table to import data from OSS at a high speed

Maximum rows per OSS export object

When the number of exported rows exceeds the limit, extra rows are written to one or more new objects. Both the maximum object size and the maximum number of rows can be specified. The written data that first triggers the limit is exported to a new object.

—

Execution plan in the console

Execution plans of slow SQL queries can now be viewed in the AnalyticDB for PostgreSQL console.

—

INSERT INTO SELECT ON DUPLICATE KEY UPDATE

This query is supported when UPDATE column values are constants or when they come from the SELECT column.

—

ORC format for OSS external tables

The ORC format is now supported for OSS external tables.

—

Priority for BATCH LOAD statements

The priority of BATCH LOAD statements can be specified using hints.

—

BOOL and BOOLEAN types

The BOOL and BOOLEAN types are now supported in table creation statements.

—

Database naming conventions

Database names can now start with an uppercase letter or an underscore (_).

—

Feature

Description

References

LIMIT n performance

Performance is improved when using the pushdown logic of the LIMIT n statement to filter data.

—

Feature

Description

References

AnalyticDB for MySQL V2.0 time format

Time formats from AnalyticDB for MySQL V2.0 are now supported. Example: 2020-08-03T23:59:59.

—