AnalyticDB for PostgreSQL V7.0 is built on PostgreSQL 12, bringing stronger security controls, broader SQL compatibility, and measurable query performance gains over previous versions.
V7.0 is available only for instances in elastic storage mode.
What's new in V7.0
Enterprise-class capabilities
| Feature | What it does |
|---|
| Stored procedures | Supports CREATE FUNCTION and CREATE PROCEDURE, enabling server-side business logic without client round-trips. |
| Generated column | Automatically computes column values from other columns, keeping derived data consistent without application logic. |
Features and performance
| Feature | What it does |
|---|
| Table partitions | Adds hash partitions alongside existing range and list partitions, using standard PostgreSQL syntax. |
| Window functions | Full SQL:2011 window function support for ranking, running totals, and moving averages. |
| Column group statistics | Lets you specify which column combinations to collect statistics on, improving cost estimation and query plan quality. |
| JSON functions | Expanded set of JSON functions for richer document querying. |
| Covering indexes | Includes additional columns in an index to satisfy more queries without a table lookup. |
| JIT compilation | Just-in-time (JIT) compilation accelerates CPU-intensive expressions at query execution time. |
| Aggregate function reuse | Avoids redundant aggregation by reusing results when the same aggregation appears multiple times in a query. |
| Indexes | Adds Hash, BRIN, and Bloom index types; optimizes B-tree, GIN, GiST, and Bitmap indexes. |
Engine features
AnalyticDB for PostgreSQL V7.0 supports most PostgreSQL features and uses the same syntax.
| Category | Feature | Supported |
|---|
| Basic features | ALTER TABLE | Yes |
| Indexes | Yes |
| Primary keys | Yes |
| Unique constraints | Yes |
| INSERT ON CONFLICT | Yes |
| Table unlogging | Yes |
| Triggers | No — triggers are not supported in this version |
| Heap tables, append-optimized row-oriented (AORO) tables, and append-optimized column-oriented (AOCO) tables | Yes |
| Custom data types | Yes |
| Explicit cursors | Yes |
| Compute engines | Orca optimizer | Yes |
| Laser engine | Yes |
| Transaction capabilities | Subtransactions | Yes |
| Transaction isolation levels | Yes — Read Committed and Repeatable Read |
| Advanced features | Backup and restoration | Yes |
| Materialized views | Yes |
| Auto-vacuum | Yes — system tables only |
| Auto-analyze | Yes |
| Elastic scale-out | Yes |
| Elastic scale-in | No — scale-in is not supported; submit a ticket if you need to reduce compute nodes |
| GIS/GanosBase | Yes |
| Data sharing | No — data sharing is not supported in V7.0 |
Console features
| Category | Feature | Supported |
|---|
| Instance management | Basic instance information | Yes |
| Log in to databases using Data Management (DMS) | Yes |
| Instance creation | Yes |
| Instance release | Yes |
| Instance restart | Yes |
| Instance configuration upgrade or downgrade | Yes |
| Coordinator node addition or removal | No — coordinator node count cannot be changed after instance creation |
| Instance scale-out | Yes |
| Instance scale-in | No — scale-in is not supported in the console; submit a ticket if needed |
| Minor version update | Yes |
| Account management | Account creation | Yes |
| Password resetting | Yes |
| Database connection | Basic connection information (endpoint and port number) | Yes |
| Public endpoint application | Yes |
| Monitoring and alerting | Monitoring | Yes |
| Alert rules | Yes |
| Data security | Whitelists | Yes |
| SQL audit | Yes |
| SSL encryption | Yes |
| Backup and restoration | Yes |
| Configuration | Parameter settings | Yes |
FAQ
Can I upgrade an elastic storage mode instance from V6.0 to V7.0?
Direct in-place upgrades from V6.0 to V7.0 are not supported. Submit a ticket to request the upgrade.