All Products
Search

This Product

    AnalyticDB:Supported extensions

    Document Center

    AnalyticDB:Supported extensions

    Last Updated:May 30, 2024

    AnalyticDB for PostgreSQL is developed by Alibaba Cloud based on PostgreSQL and supports a variety of open source and self-developed extensions. You can use the supported extensions to perform hint-based SQL optimization, job scheduling, and cross-database queries.

    Usage notes

    The supported extensions in this topic are suitable for the recommended or latest minor version of AnalyticDB for PostgreSQL. If you cannot find an extension on the Extensions page of an AnalyticDB for PostgreSQL instance, we recommend that you update the instance to the recommended or latest minor version. For information about how to update the minor version of an AnalyticDB for PostgreSQL instance, see Update the minor engine version.

    Extensions

    The following table describes the extensions supported by AnalyticDB for PostgreSQL.

    Extension name

    Elastic storage mode (V6.0)

    Elastic storage mode (V7.0)

    Serverless mode

    Description

    btree_gin

    Supported

    Supported

    Supported

    Allows you to create generalized inverted index (GIN) indexes for columns that are suitable for B-tree indexes.

    btree_gist

    Supported

    Supported

    Supported

    Uses a Generalized Search Tree (GiST) index structure to simulate B-tree behavior.

    dblink

    Supported

    Supported

    Supported

    Allows you to remotely access other PostgreSQL databases from a session of an AnalyticDB for PostgreSQL instance.

    citext

    Supported

    Supported

    Supported

    Provides a character string type that is not case-sensitive called citext.

    fuzzystrmatch

    Supported

    Supported

    Supported

    Provides fuzzy match for character strings.

    ganos_geometry

    Supported

    Supported

    Not supported

    Provides a lightweight geometry extension of Ganos.

    ganos_geometry_sfcgal

    Supported

    Supported

    Not supported

    Provides a lightweight geometry SFCGAL extension of Ganos.

    ganos_geomgrid

    Supported

    Supported

    Not supported

    Provides a geometry grid extension of Ganos.

    ganos_raster

    Supported

    Supported

    Not supported

    Provides a raster extension of Ganos.

    ganos_spatialref

    Supported

    Supported

    Not supported

    Provides a spatial reference extension of Ganos.

    ganos_trajectory

    Supported

    Supported

    Not supported

    Provides a trajectory extension of Ganos.

    hll

    Supported

    Supported

    Supported

    Estimates the numbers of different elements in a HyperLogLog collection.

    hstore

    Supported

    Supported

    Supported

    Provides a data type called hstore to store sets of key-value pairs.

    isn

    Not supported

    Supported

    Not supported

    Provides a data type called isn to support international product numbering standards.

    ltree

    Not supported

    Supported

    Not supported

    Provides a data type called ltree to store data in a hierarchical tree-like structure.

    odps_fdw

    Supported

    Supported

    Supported

    Allows you to access MaxCompute.

    orafce

    Supported

    Supported

    Supported

    Provides compatibility with specific Oracle functions.

    oss_fdw

    Supported

    Supported

    Supported

    Allows you to access Object Storage Service (OSS).

    pageinspect

    Supported

    Supported

    Supported

    Provides low-level checks on database pages.

    pg_hint_plan

    Supported

    Supported

    Supported

    Allows you to modify and optimize SQL statements by using hints to accelerate queries.

    pg_jieba

    Supported

    Supported

    Supported

    Allows you to perform Chinese full-text search.

    pg_prewarm

    Not supported

    Supported

    Not supported

    Allows you to prewarm relation data.

    pg_stat_statement

    Supported

    Supported

    Supported

    Allows you to track the execution statistics of all SQL statements that are executed.

    pg_trgm

    Supported

    Supported

    Supported

    Provides functions and operators that can be used to determine the similarity of text and index operators that support fast search for similar strings.

    pgcrypto

    Supported

    Supported

    Supported

    Supports encryption algorithm functions and allows you to store encrypted columns to further protect sensitive data.

    pldbgapi

    Supported

    Supported

    Supported

    Allows you to use the PL/pgSQL features to develop and debug functions in a simplified manner.

    postgres_fdw

    Supported

    Supported

    Supported

    Provides a PostgreSQL extension for cross-database queries.

    roaring bitmap

    Supported

    Supported

    Supported

    Provides a bitmap extension that uses the efficient roaring bitmap algorithm.

    sslinfo

    Supported

    Supported

    Supported

    Allows you to obtain the details of SSL database connections.

    tablefunc

    Supported

    Supported

    Supported

    Provides a table function extension.

    tdfunc

    Supported

    Supported

    Supported

    Allows you to use the subset features of Teradata and the features of functions and operators in Teradata.

    update_6_0_datatypecast_c

    Supported

    Supported

    Supported

    Allows you to implicitly convert data types in the C language from V4.3 to V6.0.

    uuid-ossp

    Supported

    Supported

    Supported

    Provides the UUID data type to store universally unique identifiers (UUIDs). UUIDs are more unique than sequences in distributed systems.

    zhparser

    Supported

    Supported

    Not supported

    Provides a Chinese word segmentation extension.