This topic lists the basic features and limits of AnalyticDB for PostgreSQL (formerly known as HybridDB for PostgreSQL).

Features

  • Provides the key features of Greenplum Database. For more information, see Summary of Greenplum Features.
  • Supports exclusive MetaScan and SortKey technologies. For more information, see Use sort keys 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 details about PL/Java stored procedures, see Using the PL /Java UDF.
  • Supports vector retrieval of unstructured data.
  • Supports multiple extensions such as PostGIS, MADlib, fuzzystrmatch, orafunc, pgcrypto, intarray, and Roaring Bitmap. You can use the CREATE EXTENSION command 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 Alibaba Cloud Object Storage Service (OSS), and provides gzip compression to reduce the external table storage cost. For more information, see Import or export OSS data by using OSS external tables.
  • 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
  • AnalyticDB for PostgreSQL automatically performs a full backup every weekend. You can submit a ticket to modify the backup time and period. You can also use the pg_dump tool to perform backups on your own.

Limits

  • For details about limits of the core features, see Summary of Greenplum Features.
  • Permission limits: The root user of AnalyticDB for PostgreSQL has permissions to create databases (CREATEDB) and roles (CREATEROLE), but does not have superuser permissions (SUPERUSER) 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: Nodes can load data in parallel based on OSS external tables. For more information, see Import or export OSS data by using OSS external tables
  • MapReduce APIs, gphdfs storage APIs, and local external tables are not supported.