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 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 |
Distributed | What is a distributed cluster? | Not supported | 2.0.14.17.34.0 | Not supported | 2.0.16.9.6.0 | Not supported | Not supported |
Create and manage distributed tables 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 queries on distributed tables | Not supported | 2.0.14.17.34.0 | Not supported | 2.0.16.9.6.0 | Not supported | 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 | Not supported |
Multi-tenant 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 |
Configure CDC to synchronize data changes | Not supported | 2.0.14.17.34.0 | 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 |
Columnstore 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 | TDE transparent data encryption | 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 | 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 | 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 Memory Buffer (PBP) | 2.0.11.2.1.0 | 2.0.14.5.2.0 | 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 |
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 |
Convert OR clauses to UNION ALL | Not supported | 2.0.14.13.27.0 | Not supported | Not supported | Not supported | Not supported |
Statement outline | Not supported | 2.0.14.13.28.0 | Not supported | 2.0.16.9.9.0 | 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 |
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 |
Partitioned tables support any column as primary key | Not supported | 2.0.14.10.17.0 | 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 |
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 | 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 |
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 |
Flashback table | 2.0.11.9.22.0 | Not supported | Not supported | Not supported | Not supported | Not supported |