All Products
Search
Document Center

:Overview of AnalyticDB for PostgreSQL V4.3

Last Updated:Apr 28, 2023

AnalyticDB for PostgreSQL V4.3 is built based on Greenplum 4.3 that uses a massively parallel processing (MPP) architecture and PostgreSQL 8.2.

Features

  • Supports exclusive MetaScan and SortKey technologies. For more information, see Use sort keys and rough set indexes to accelerate queries in column-oriented tables.

  • Supports the next-generation ORCA optimizer based on Cascade Framework.

  • Supports distributed stored procedures in PL/pgSQL and PL/Java. For more information about PL/Java stored procedures, see Create and use PL/Java UDFs.

  • Supports vector retrieval of unstructured data.

  • Supports multiple extensions such as PostGIS, MADlib, fuzzystrmatch, orafunc, pgcrypto, intarray, and RoaringBitmap. You can execute the CREATE EXTENSION statement to create them. For more information, see Manage extensions.

  • Allows you to use the OSS_EXT extension to read data from or write data to Object Storage Service (OSS), and provides GZIP compression to reduce the external table storage costs. For more information, see Use an external table to import data from OSS at a high speed.

  • Supports the JSON data type. For more information, see Manage JSON and JSON-B data.

    Note

    The JSONB data type is not supported.

  • Supports the HypeLogLog data type. For more information, see Use HyperLogLog

  • Automatically performs a full backup every weekend. You can also use the pg_dump tool to perform backups on your own.

Limits

  • The root user of AnalyticDB for PostgreSQL has permissions to create databases and roles, but does not have superuser permissions and cannot perform operations that require such permissions. For example, the root user cannot run file functions such as pg_ls_dir. However, the root user has permissions to view and modify data of other non-superusers and terminate their connections.

  • PL/R extensions are not supported.

  • PL/Python extensions can be created but functions cannot be created with PL/Python.

  • The gpfdist tool is not supported. Note: Data can be loaded in parallel based on OSS external tables. For more information, see Use an external table to import data from OSS at a high speed.

  • MapReduce API operations, gphdfs storage API operations, and local external tables are not supported.