Overview

Updated at:
Copy as MD

This topic covers the features of the major and kernel minor versions of PolarDB for PostgreSQL and .

Note
  • The listed minor kernel version is the minimum required for the corresponding feature.

  • Supported: The current major kernel version supports the feature without version restrictions.

  • Not supported: The current major kernel version does not support the feature.

Feature

PolarDB for PostgreSQL

11

14

15

16

17

18

Enterprise Edition

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 autonomous services

Off-peak garbage collection

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

Not supported

Not supported

Not supported

Not supported

Distributed

Distributed cluster overview

Not supported

2.0.14.17.34.0

Not supported

2.0.16.9.6.0

Not supported

Not supported

Manage distributed and replicated tables

Not supported

2.0.14.17.34.0

Not supported

2.0.16.9.6.0

Not supported

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

Not supported

Optimize distributed table queries

Not supported

2.0.14.17.34.0

Not supported

2.0.16.9.6.0

Not supported

Not supported

Distributed sequence usage and limitations

Not supported

2.0.14.17.34.0

Not supported

2.0.16.9.6.0

Not supported

Not supported

Multi-tenancy management

Not supported

2.0.14.17.34.0

Not supported

2.0.16.9.6.0

Not supported

Not supported

Tenant isolation

Not supported

2.0.14.17.34.0

Not supported

2.0.16.9.6.0

Not supported

Not supported

Synchronizing data changes with change data capture (CDC)

Not supported

2.0.14.17.34.0

Not supported

2.0.16.9.6.0

Not supported

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

Not supported

Not supported

Not supported

Not supported

HTAP

Real-time materialized views

2.0.11.9.27.0

2.0.14.8.11.0

Not supported

Not supported

Not supported

Not supported

Not supported

In-Memory Columnar 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

AI

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

Not supported

Supabase applications

Not supported

Not supported

Not supported

Supported

Not supported

Not supported

Not supported

DynamoDB compatibility

Not supported

2.0.14.17.35.0

Not supported

Not supported

Not supported

Not supported

Not supported

Global Database Network (GDN)

Not supported

Supported

Not supported

Not supported

Not supported

Not supported

Intelligent Search (PolarSearch)

Not supported

2.0.14.22.43.0

Not supported

2.0.15.17.8.0

2.0.16.11.15.0

Not supported

2.0.17.9.6.0

2.0.18.3.2.0

Memory optimization

Persistent Buffer Pool (PBP)

2.0.11.2.1.0

2.0.14.5.2.0

Not supported

Not supported

Not supported

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 (Global Cache)

Not supported

2.0.14.8.11.0

Not supported

Not supported

Not supported

Not supported

Optimizer

Cost-based query transformation (CBQT)

2.0.11.15.44.0

2.0.14.13.28.0

Not supported

Not supported

Not supported

Not supported

OR-to-UNION ALL conversion

Not supported

2.0.14.13.27.0

Not supported

Not supported

Not supported

Not supported

Plan pinning (STATEMENT OUTLINE)

Not supported

2.0.14.13.28.0

Not supported

2.0.16.9.9.0

Not supported

Not supported

Not supported

Sublink pushdown

2.0.11.15.44.0

2.0.14.13.28.0

Not supported

Not supported

Not supported

Not supported

Correlated subquery pull-up

Not supported

2.0.14.8.11.0

Not supported

Not supported

Supported

Supported

Partitioned tables

Global indexes

Not supported

2.0.14.9.15.0

Not supported

Not supported

Not supported

Not supported

Support for any-column primary keys on partitioned tables

Not supported

2.0.14.10.17.0

Not supported

Not supported

Not supported

Not supported

Partitioned table scan operator

Not supported

2.0.14.9.15.0

Not supported

Not supported

Not supported

Not supported

Resource management

Multi-tenancy

Not supported

2.0.14.12.24.0

Not supported

Not supported

Not supported

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

Tiered storage for cold data

Not supported

2.0.14.10.21.0

Not supported

Not supported

2.0.16.9.6.0

Not supported

Not supported

Not supported

Storage performance

Prefetching and pre-extension

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 writes for materialized view creation and refresh

2.0.11.15.37.0

2.0.14.9.15.0 to 2.0.14.13.27.0

Not supported

Not supported

Not supported

Not supported

Multi-insert table AM

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

Bulk import

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

Table 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

Direct WAL buffer reads for physical and logical replication

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

Miscellaneous

Flashback drop

2.0.11.9.30.0

2.0.14.9.15.0

Not supported

Not supported

Not supported

Not supported

Flashback table

2.0.11.9.22.0

Not supported

Not supported

Not supported

Not supported

Not supported