This topic lists the features supported by each major engine version and edition of PolarDB for PostgreSQL, along with the minimum minor engine version required for each feature.
Note
Version numbers shown are the minimum required minor engine version for each feature. All later minor versions of the same major version also support the feature.
Supported: The feature is available across all minor versions of that major engine version.
Not supported: The feature is not available for that major engine version.
— (dash): The edition does not exist for that major engine version, or the feature does not apply to that edition.
| Feature | PolarDB for PostgreSQL 11 | PolarDB for PostgreSQL 14 | PolarDB for PostgreSQL 15 | PolarDB for PostgreSQL 16 | PolarDB for PostgreSQL 17 | PolarDB for PostgreSQL 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 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 | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | — | — | — |
| Distributed | |||||||||||||
| What is a distributed cluster? | Not supported | Not supported | — | 2.0.14.17.34.0 | Not supported | Not supported | Not supported | — | 2.0.16.9.6.0 | Not supported | — | Not supported | — |
| Create and manage distributed tables and replicated tables | Not supported | Not supported | — | 2.0.14.17.34.0 | Not supported | Not supported | Not supported | — | 2.0.16.9.6.0 | Not supported | — | Not supported | — |
| DML operations on distributed tables | Not supported | Not supported | — | 2.0.14.17.34.0 | Not supported | Not supported | Not supported | — | 2.0.16.9.6.0 | Not supported | — | Not supported | — |
| Optimize queries on distributed tables | Not supported | Not supported | — | 2.0.14.17.34.0 | Not supported | Not supported | Not supported | — | 2.0.16.9.6.0 | Not supported | — | Not supported | — |
| Use and limits of distributed sequences | Not supported | Not supported | — | 2.0.14.17.34.0 | Not supported | Not supported | Not supported | — | 2.0.16.9.6.0 | Not supported | — | Not supported | — |
| Multi-tenant management | Not supported | Not supported | — | 2.0.14.17.34.0 | Not supported | Not supported | Not supported | — | 2.0.16.9.6.0 | Not supported | — | Not supported | — |
| Tenant isolation | Not supported | Not supported | — | 2.0.14.17.34.0 | Not supported | Not supported | Not supported | — | 2.0.16.9.6.0 | Not supported | — | Not supported | — |
| Configure CDC to synchronize data changes | Not supported | Not supported | — | 2.0.14.17.34.0 | Not supported | Not supported | Not supported | — | 2.0.16.9.6.0 | Not supported | — | Not supported | — |
| Fast recovery | |||||||||||||
| Online promote 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 WAL log replay | 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 | — | — | Not supported | — | — | — |
| Columnstore index (IMCI) | Not supported | 2.0.14.10.20.0 | Not supported | — | 2.0.15.15.7.0 | — | 2.0.16.8.3.0 | — | — | 2.0.17.7.5.0 | — | Not supported | — |
| Security and reliability | |||||||||||||
| TDE transparent data encryption | 2.0.11.2.1.0 | 2.0.14.5.1.1 | — | — | Not supported | — | 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 | Not supported | Not supported | — | Not supported | — | — | Not supported | — | — | — |
| 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 | — | 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 | — | — | Not supported | — | — | — |
| Global database network (GDN) | Not supported | Supported | Not 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 | — | — | 2.0.17.9.6.0 | — | 2.0.18.3.2.0 | — |
| Memory optimization | |||||||||||||
| Persistent Memory Buffer (PBP) | 2.0.11.2.1.0 | 2.0.14.5.2.0 | Not supported | — | Not supported | — | Not supported | — | — | Not supported | — | Not supported | — |
| Global execution 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 | — | 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 | — | Not supported | — |
| Convert OR clauses to UNION ALL | Not supported | 2.0.14.13.27.0 | Not supported | — | Not supported | — | Not supported | — | — | Not supported | — | Not supported | — |
| Statement outline | Not supported | 2.0.14.13.28.0 | Not supported | — | Not supported | — | 2.0.16.9.9.0 | Not supported | Not supported | Not supported | — | Not supported | — |
| Subquery pushdown | 2.0.11.15.44.0 | 2.0.14.13.28.0 | Not supported | — | Not supported | — | Not supported | — | — | Not supported | — | Not supported | — |
| Correlated subquery pull-up | Not supported | 2.0.14.8.11.0 | Not supported | — | Not supported | — | Not supported | — | Supported | Supported | — | Not supported | — |
| Partitioned tables | |||||||||||||
| Global indexes | Not supported | 2.0.14.9.15.0 | Not supported | — | Not supported | — | Not supported | — | — | Not supported | — | Not supported | — |
| Partitioned tables support any column as primary key | Not supported | 2.0.14.10.17.0 | Not supported | — | Not supported | — | Not supported | — | — | Not supported | — | Not supported | — |
| Partitioned table scan operators | Not supported | 2.0.14.9.15.0 | Not supported | — | Not supported | — | Not supported | — | — | Not supported | — | Not supported | — |
| Resource management | |||||||||||||
| Multi-tenant | 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 | — | Not supported | — | 2.0.16.9.6.0 | 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 | — |
| Create or refresh materialized views with batch writes | 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 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 | — |
| 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 | — |
| Physical and logical replication reads WAL logs from 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 | — |
| Other | |||||||||||||
| Flashback drop | 2.0.11.9.30.0 | 2.0.14.9.15.0 | Not supported | — | 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 | — | Not supported | — |