Features supported by different versions and minor engine versions of PolarDB for PostgreSQL - PolarDB

This topic lists the features supported by the major versions and minor engine versions of PolarDB for PostgreSQL and .

Note

The minor engine versions listed are the minimum versions required for the corresponding features.
Supported: The feature is supported by the specified major engine version, regardless of the minor version.
Not supported: The feature is not supported by the specified major engine version.

Feature

PolarDB for PostgreSQL

Enterprise Edition

Standard Edition

Distributed Edition

Enterprise Edition

Standard Edition

Enterprise Edition

Standard Edition

Distributed Edition

Enterprise Edition

Standard Edition

Enterprise Edition

Standard Edition

Database Autonomy Service

Garbage collection during off-peak hours

2.0.11.15.42.0

2.0.14.12.24.0

2.0.15.12.4.0

2.0.16.8.3.0

2.0.17.2.2.1

Not supported

Automatic index recommendation

Not supported

2.0.14.10.19.0

Not supported

Distributed

Not supported

2.0.14.17.34.0

Not supported

2.0.16.9.6.0

Not supported

Create and manage distributed and replicated tables

Not supported

2.0.14.17.34.0

Not supported

2.0.16.9.6.0

Not supported

DML operations on distributed tables

Not supported

2.0.14.17.34.0

Not supported

2.0.16.9.6.0

Not supported

Optimize queries on distributed tables

Not supported

2.0.14.17.34.0

Not supported

2.0.16.9.6.0

Not supported

Use and limits of distributed sequences

Not supported

2.0.14.17.34.0

Not supported

2.0.16.9.6.0

Not supported

Tenant isolation

Not supported

2.0.14.17.34.0

Not supported

2.0.16.9.6.0

Not supported

Configure CDC to synchronize data changes

Not supported

2.0.14.17.34.0

Not supported

2.0.16.9.6.0

Not supported

Elastic Parallel Query (ePQ)

Cross-node parallel acceleration for creating materialized views

2.0.11.9.30.0

2.0.14.6.6.0

Not supported

Control ePQ usage based on table size or cost

Not supported

2.0.14.9.15.0

Not supported

View and analyze execution plans for ePQ

2.0.11.9.22.0

2.0.14.6.6.0

Not supported

Compute node range selection and degree of parallelism control

2.0.11.9.20.0

2.0.14.6.6.0

Not supported

ePQ support for parallel writes to and queries on OSS foreign tables

2.0.11.9.35.0

2.0.14.9.13.0

Not supported

ePQ support for partitioned table queries

2.0.11.9.17.0

2.0.14.8.11.0

Not supported

Parallel INSERT

2.0.11.9.17.0

2.0.14.8.12.0

Not supported

Fast recovery

Online promotion of read-only nodes

2.0.11.2.1.0

2.0.14.5.1.0

2.0.15.7.1.1

2.0.16.3.1.1

2.0.17.2.1.0

2.0.18.0.1.0

Parallel replay of WAL logs

2.0.11.9.17.0

2.0.14.5.1.0

2.0.15.7.1.1

2.0.16.3.1.1

2.0.17.2.1.0

2.0.18.0.1.0

Logical replication slot failover

2.0.11.15.38.0

Not supported

HTAP

Real-time materialized views

2.0.11.9.27.0

2.0.14.8.11.0

Not supported

In-Memory Column Index (IMCI)

Not supported

2.0.14.10.20.0

2.0.15.15.7.0

2.0.16.8.3.0

2.0.17.7.5.0

Not supported

Security and reliability

Transparent data encryption (TDE)

2.0.11.2.1.0

2.0.14.5.1.1

Not supported

2.0.16.9.6.0

2.0.17.6.4.0

2.0.18.0.1.0

Confidential database (public preview)

Not supported

2.0.14.9.14.0

Not supported

PolarDB for AI

Not supported

2.0.14.13.28.0

2.0.15.12.4.0

2.0.16.6.2.0

Not supported

Supabase applications

Not supported

Supported

Not supported

DynamoDB compatibility

Not supported

2.0.14.17.35.0

Not supported

Global database network (GDN)

Not supported

Supported

Not supported

Memory optimization

Persistent Buffer Pool (PBP)

2.0.11.2.1.0

2.0.14.5.2.0

Not supported

Global Plan Cache (GPC)

2.0.11.9.28.0

2.0.14.9.15.0

2.0.15.7.1.1

2.0.16.3.1.1

2.0.17.2.1.0

2.0.18.0.1.0

Global Metadata Cache

Not supported

2.0.14.8.11.0

Not supported

Optimizer

Cost-based query transformation (CBQT)

2.0.11.15.44.0

2.0.14.13.28.0

Not supported

OR-to-UNION ALL transformation

Not supported

2.0.14.13.27.0

Not supported

Statement outline

Not supported

2.0.14.13.28.0

Not supported

2.0.16.9.9.0

Not supported

Subquery pushdown

2.0.11.15.44.0

2.0.14.13.28.0

Not supported

Correlated subquery unnesting

Not supported

2.0.14.8.11.0

Not supported

Supported

Partitioned tables

Global indexes

Not supported

2.0.14.9.15.0

Not supported

Support for any column as the primary key of a partitioned table

Not supported

2.0.14.10.17.0

Not supported

Partitioned table scan operator

Not supported

2.0.14.9.15.0

Not supported

Resource Management

Multi-tenancy

Not supported

2.0.14.12.24.0

Not supported

Resource Manager

2.0.11.2.1.0

2.0.14.5.1.0

2.0.15.7.2.0

2.0.16.3.1.1

2.0.17.2.1.0

2.0.18.0.1.0

Storage cost

Cold data tiering

Not supported

2.0.14.10.21.0

Not supported

2.0.16.9.6.0

Not supported

Storage performance

Prefetch and pre-extend

2.0.11.2.0.0

2.0.14.5.1.0

2.0.15.12.4.0

2.0.16.6.2.0

2.0.17.2.1.0

2.0.18.0.1.0

Batch write support for creating and refreshing materialized views

2.0.11.15.37.0

2.0.14.9.15.0 to 2.0.14.13.27.0

Not supported

Multi-insert table AM infrastructure

Not supported

2.0.14.13.28.0

2.0.15.12.4.0

2.0.16.8.3.0

2.0.17.2.2.1

Not supported

Batch import infrastructure

Not supported

2.0.14.13.28.0

2.0.15.12.4.0

2.0.16.6.2.0

2.0.17.2.1.0

2.0.18.0.1.0

Relation Size Cache (RSC)

Not supported

2.0.14.12.23.1

2.0.15.7.1.1

2.0.16.3.1.1

2.0.17.2.1.0

2.0.18.0.1.0

Physical/Logical replication support for reading WAL logs from the WAL buffer

Not supported

2.0.14.13.27.0

2.0.15.12.4.0

2.0.16.6.2.0

2.0.17.2.1.0

2.0.18.0.1.0

Others

Flashback drop

2.0.11.9.30.0

2.0.14.9.15.0

Not supported

Flashback table

2.0.11.9.22.0

Not supported