All Products
Search

This Product

    AnalyticDB:AnalyticDB for PostgreSQL V7.0

    Document Center

    AnalyticDB:AnalyticDB for PostgreSQL V7.0

    Last Updated:Apr 01, 2026

    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.

    Performance

    On the TPC-H benchmark (22 queries), the Laser compute engine delivers approximately 5x the query throughput of the native Greenplum compute engine. For benchmark methodology and full results, see TPC-H performance testing for AnalyticDB for PostgreSQL V7.0.

    What's new in V7.0

    Security

    Feature What it does
    Row security policies Restricts which rows a database account can read or modify, giving you fine-grained access control at the row level.
    Security enhancement on password encryption and SSL encryption Adds SCRAM-SHA-256 authentication, a stronger alternative to MD5, to protect credentials in transit.
    Dynamic data masking Masks sensitive columns for specific users with configurable masking functions, so different roles see different data representations.

    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

    Data migration

    Migration type Reference Supported
    Data write Use INSERT ON CONFLICT to overwrite data Yes
    Use COPY ON CONFLICT to overwrite data Yes
    Use AnalyticDB for PostgreSQL Client SDK to write data Yes
    Table data migration Use Data Integration to migrate and batch synchronize data Yes
    Use DTS to synchronize data from cloud databases Yes
    Use DTS to synchronize data from self-managed databases Yes
    Use the \copy command to import data from your computer Yes
    Use an external table to import data from OSS Yes
    Use external tables for federated analytics of Hadoop data sources Yes
    Warehouse data migration Migrate data from a self-managed Greenplum cluster Yes
    Migrate data from a Teradata database No — use external tables to import data
    Migrate data from an Amazon Redshift cluster No — use external tables to import data
    Migrate data from a self-managed Oracle application No — use external tables to import data
    Migrate data from a self-managed Oracle database No — use external tables to import data

    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.