All Products
Search

This Product

    AnalyticDB:Limits

    Document Center

    AnalyticDB:Limits

    Last Updated:Aug 09, 2024

    To ensure the stability and security of instances, AnalyticDB for PostgreSQL is subject to the following limits.

    You do not need to perform basic database O&M operations such as ensuring high availability and installing security patches for purchased AnalyticDB for PostgreSQL instances. However, you must take note of the following items:

    • Instance update: Instances are read-only during minor version updates. A transient connection of up to 30 seconds may occur after an update is complete. Make sure that your application is configured with automatic reconnection policies such as a connection pool.

    • Failover: The coordinator and compute nodes each adopt a primary/secondary high-availability architecture. When an error occurs on the primary node, the service is automatically switched over to the secondary node within 30 seconds. A transient connection of about 30 seconds may occur during the failover. Make sure that your application is configured with automatic reconnection policies such as a connection pool.

    Metric

    Limits

    Maximum number of user connections

    The maximum number of connections varies based on compute node specifications:

    • Elastic storage mode

      • High-availability Edition

        • 2 cores, 16 GB: 300

        • 4 cores, 32 GB: 600

        • 8 cores, 64 GB: 1,200

        • 16 cores, 128 GB: 2,433

      • High-performance Edition (Basic Edition)

        • 2 cores, 8 GB: 133

        • 4 cores, 16 GB: 300

        • 8 cores, 32 GB: 600

        • 16 cores, 64 GB: 1,200

    • Serverless mode

      • 4 cores, 16 GB: 375

      • 8 cores, 32 GB: 750

      • 16 cores, 64 GB: 1,500

    Maximum data volume in a column

    1 GB

    Maximum data volume of a database

    The maximum data volume of a database varies based on instance specifications.

    Maximum data volume of a table

    128 TB per partition

    Maximum volume of BLOB data

    1 GB

    Note

    In AnalyticDB for PostgreSQL, the BYTEA data type is used in place of the BLOB data type.

    Maximum number of rows in a table

    2^48

    Maximum number of columns in a table

    1,600

    Maximum number of tables in a database

    4.2 billion

    Maximum number of columns in a view

    1,664

    Maximum number of characters in the name of a row, table, or database

    128

    Maximum number of characters in the name of an object (database, user, base table, view, index, stored procedure, UDF, UDT, constraint, or column)

    63

    Maximum number of columns in a primary or secondary index

    32

    Maximum number of columns specified in a SELECT statement

    1,664

    Trigger

    Not supported