2022

Feature

Description

References

Instance specification downgrade

To help you reduce costs, AnalyticDB for PostgreSQL in elastic storage mode now supports instance specification downgrade. You can reduce the number of compute nodes in an instance based on your business needs.

Change compute node configurations

Feature

Description

References

Version 7.0

AnalyticDB for PostgreSQL has developed the cloud-native data warehouse AnalyticDB for PostgreSQL Version 7.0 based on PostgreSQL 12. Version 7.0 is more competitive in terms of features, performance, enterprise-level capabilities, and security.

AnalyticDB for PostgreSQL V7.0

Lock diagnostics

The diagnostics and optimization feature for AnalyticDB for PostgreSQL in elastic storage mode now includes lock diagnostics. This lets you view information about lock waits and lock holders in your database in real time.

Lock diagnostics

Feature

Description

References

Global overview

AnalyticDB for PostgreSQL introduced a new global overview page. This page lets you quickly and easily manage your AnalyticDB for PostgreSQL instances.

Global overview

Feature

Description

References

Sample dataset

AnalyticDB for PostgreSQL now provides a sample dataset, so you can quickly try out or test your AnalyticDB for PostgreSQL instance.

• Manage sample datasets

• Dataset information and example queries

Plan management

AnalyticDB for PostgreSQL in Serverless mode introduces plan management for pause and resume an instance and Change Instance Specifications. You can now create custom, time-based schedules to manage your resources.

Manage plans

Feature

Description

References

Manual pause and resume

AnalyticDB for PostgreSQL in Serverless mode supports on-demand pause and resume. While an instance is paused, you are charged only for storage resources, and fees for computing resources are waived.

Manually pause and resume an instance

Per-second billing

AnalyticDB for PostgreSQL now supports per-second billing for computing resources and storage resources (storage resources in elastic storage mode only), and bills are aggregated hourly. The total price per hour for the same specifications remains unchanged. When you change instance specifications or pause and resume an instance, charges are calculated based on the instance specifications and status.

Per-second billing

New region: South Korea (Seoul)

On August 1, 2022, AnalyticDB for PostgreSQL became available in availability zone A of the South Korea (Seoul) region. You can create instances in elastic storage mode in this region.

• Overview

• Create an instance

Feature

Description

References

Diagnostics and optimization

The AnalyticDB for PostgreSQL diagnostics and optimization feature has been enhanced with three new pages: Overview, Key Metrics, and Query Analysis.

• Overview: View the connection, cluster, and storage status of your instance from the console.

• Key Metrics: Monitor data bloat, data skew, and index usage from the console.

• Query Analysis: View the history and status of SQL queries. You can also analyze query execution in detail by using the provided execution plan data.

• Instance status overview

• Data bloat, data skew, and index statistics

• Query diagnostics

Feature

Description

References

Serverless mode launched in US (Virginia)

On June 29, 2022, AnalyticDB for PostgreSQL launched Serverless mode in availability zone A of the US (Virginia) region.

Serverless mode

Feature

Description

References

Event center

The AnalyticDB for PostgreSQL console now includes an event center. In addition to receiving notifications by SMS, voice call, email, or internal messages, you can view all operations and maintenance (O&M) event notifications directly in the console.

• View and manage scheduled events

• Event types

Feature

Description

References

Data sharing

AnalyticDB for PostgreSQL in Serverless mode supports data sharing. This feature uses a write-once, read-many architecture that lets you access data across different clusters without complex import and export processes. This simplifies data access, improves efficiency, and reduces costs.

• Enable or disable data sharing

• Data sharing SQL

Feature

Description

References

Monitoring and alerting

The monitoring and alerting feature for AnalyticDB for PostgreSQL has been upgraded to provide better visibility into instance status, performance, and load. You can now view monitoring metrics at two levels:

• Instance-level monitoring: A new Performance & load page helps you quickly check the overall health of your instance.

• Node-level monitoring: A new Node Monitoring page is added, which includes monitoring for Coordinator Nodes and Compute Nodes. This helps you quickly identify usage skew on a single node and take protective measures. If you have a large number of nodes, AnalyticDB for PostgreSQL also supports sorting by usage to help you quickly identify abnormal nodes.

Additionally, on the instance details page, the Instance Status section within the Basic Information tab has been updated. This section now includes health checks for connection and storage status, and provides an improved display of storage usage.

Console:

• Instance monitoring

• Node monitoring

API:

• View instance performance data

• DescribeHealthStatus

Metric reference:

Performance metrics