AnalyticDB for PostgreSQL V7.0

Category

Feature

Description

-

Codebase

The AnalyticDB for PostgreSQL kernel is based on PostgreSQL 12.

Security

Row security policy

You can use a row security policy to control which rows in a table a user can access.

Password management

Supports the SCRAM-SHA-256 authentication method, which provides higher security than the MD5 method.

Dynamic data masking

You can set column-level data masking rules and assign masking policies to specific users. This feature protects sensitive data by dynamically masking it based on the user who is viewing it.

Enterprise-grade capabilities

Stored procedure

Supports the CREATE FUNCTION and CREATE PROCEDURE statements.

Generated column

Supports generated columns, which are special columns computed from other columns in a table.

Features and performance

Table partition

Supports hash partitions in addition to range and list partitions. The syntax for hash partitions is compatible with PostgreSQL.

Window functions

Supports all SQL:2011 standard functions.

Column group statistics

You can specify the columns for which to collect statistics. This improves the accuracy of cost estimation and query performance.

JSON

More JSON functions are supported.

Covering indexes

You can include additional columns in an index to expand its coverage and improve query performance.

JIT compilation

Supports just-in-time (JIT) compilation to improve query performance.

Aggregate function reuse

Supports aggregate function reuse. When multiple reusable aggregate functions are used on the same column, the aggregation is performed only once.

Indexes

Hash, BRIN, and Bloom indexes are added. B-tree, GIN, GiST, and Bitmap indexes are optimized.

Category

Feature

Supported

Basic features

ALTER TABLE

Yes

Indexes

Yes

PRIMARY KEY

Yes

UNIQUE CONSTRAINT

Yes

INSERT ON CONFLICT (upsert)

Yes

Unlogged tables

Yes

Triggers

No

Heap, AO, and AOCS tables

Yes

Custom data types

Yes

Explicit cursors

Yes

Compute engines

Orca optimizer

Yes

Laser engine

Yes

Transaction capabilities

Subtransactions

Yes

Transaction isolation levels

Supports Read Committed (RC) and Repeatable Read (RR) isolation levels.

Advanced features

Backup and restoration

Yes

Materialized view

Yes

AUTO VACUUM

Partially supported (only for system tables)

AUTO ANALYZE

Yes

Elastic scale-out

Yes

Elastic scale-in

No

GIS/Ganos

Yes

Data sharing

No

Category

Feature

Supported

Instance management

Basic instance information

Yes

Log on to databases by using DMS

Yes

Instance creation

Yes

Instance release

Yes

Instance restart

Yes

Instance configuration upgrade or downgrade

Yes

coordinator node scaling

Not supported

Instance scale-out

Yes

Instance scale-in

Not supported

Minor version update

Yes

Account management

Account creation

Yes

Password reset

Yes

Database connection

Basic connection information (such as endpoints and ports)

Yes

Public endpoint creation

Yes

Monitoring and alerting

Monitoring

Yes

Alert rules

Yes

Data security

Whitelists

Yes

SQL audit

Yes

SSL

Yes

Backup and restoration

Yes

Configuration

Parameter settings

Yes

Migration type

Documentation

Supported

Data writing

Use INSERT ON CONFLICT to upsert data

Yes

Use COPY ON CONFLICT to overwrite imported data

Yes

Write data by using a client SDK

Yes

Table-level migration

Import data by using DataWorks

Yes

Synchronize data from an ApsaraDB database by using DTS

Yes

Synchronize data from a self-managed database by using DTS

Yes

Use the \COPY command to import local data

Yes

Use an OSS external table for high-speed import of OSS data

Yes

Use external tables for federated queries of Hadoop data sources

Yes

Warehouse-level migration

Migrate data from a self-managed Greenplum database to AnalyticDB for PostgreSQL

Yes

Migrate Teradata applications to AnalyticDB for PostgreSQL

Not supported

You can import data by using external tables.

Manually migrate data from Amazon Redshift to AnalyticDB for PostgreSQL

Not supported

You can import data by using external tables.

Migrate Oracle applications to the cloud-native data warehouse AnalyticDB for PostgreSQL

Not supported

You can import data by using external tables.

Migrate data from a self-managed Oracle database to the cloud-native data warehouse AnalyticDB for PostgreSQL

Not supported

You can import data by using external tables.