All Products
Search

This Product

    PolarDB:Extensions of PolarDB for PostgreSQL

    Document Center

    PolarDB:Extensions of PolarDB for PostgreSQL

    Last Updated:Oct 25, 2024

    This topic describes the extensions supported by different versions of PolarDB for PostgreSQL clusters.

    Note

    • If the extensions supported by your PolarDB for PostgreSQL cluster do not match the extensions described in the following section, update the minor engine version of your cluster to the latest. For more information, see Version management.

    • The following section describes the commonly used extensions. For information about all extensions supported by your cluster, run the SELECT * FROM pg_available_extensions; statement in the cluster.

    • Before you use some extensions, you must add the names of the extensions to the value of the shared_preload_libraries parameter of your cluster. Otherwise, you cannot create the extensions.

      • The involved extensions include pg_stat_statements, auth_delay, passwordcheck, auto_explain, pgaudit, pg_bigm, pg_cron, pg_hint_plan, pg_prewarm, zhparser, timescaledb, pldebugger, and pg_jieba.

      • If you want to use the pldebugger extension, you must add plugin_debugger to the value of the shared_preload_libraries parameter of your cluster.

    • For information about how to modify the shared_preload_libraries parameter, see Specify cluster parameters.

    • If the ERROR: permission denied for database postgres error message appears when you create an extension such as ganos_spatialref in the default Postgres database, switch to a database that belongs to the current account to create the extension.

    Important

    PolarDB for PostgreSQL allows you to modify extension policies. Starting April 27, 2023, specific extensions can be created only in a PolarDB for PostgreSQL cluster that runs one of the specified minor engine versions. Existing extensions are not affected. For more information, see Some extensions cannot be created in earlier versions of PolarDB for PostgreSQL as of April 27, 2023.

    Clusters that use the X86 architecture

    Extension

    PostgreSQL 15

    PostgreSQL 14

    PostgreSQL 11

    Description

    AGE

    1.5.0

    1.5.0

    -

    This extension allows you to query graphs in a database by using Cypher.

    address_standardizer

    3.1.4

    3.1.4

    3.1.4

    This extension provides the address standardization service.

    address_standardizer_data_us

    3.1.4

    3.1.4

    3.1.4

    This extension provides the address standardization service. You can use this extension to format and standardize American addresses.

    bloom

    1.0

    1.0

    1.0

    This extension provides an index access method that is based on Bloom filters.

    btree_gin

    1.0

    1.3

    1.3

    This extension provides sample Generalized Inverted Index (GIN) operator classes that are used to implement B-tree equivalent behavior for multiple data types or all enumerated data types.

    btree_gist

    1.6

    1.6

    1.5

    This extension provides sample GiST operator classes that are used to implement B-tree equivalent behavior for multiple data types or all enumerated data types.

    citext

    1.6

    1.6

    1.5

    This extension provides a string type that is case-insensitive.

    cube

    1.5

    1.5

    1.4

    This extension provides a data type that is used to represent multidimensional cubes.

    dblink

    1.2

    1.2

    1.2

    This extension is used to manage tables across databases.

    decoderbufs

    -

    0.10.0

    0.10.0

    This extension is used to generate data that is compatible with the Debezium platform based on the Protocol Buffers protocol.

    dict_int

    1.0

    1.0

    1.0

    This extension provides a sample add-on dictionary template that is used to perform full-text searches.

    earthdistance

    1.1

    1.1

    1.1

    This extension provides two different methods that can be used to calculate great-circle distances on the surface of the Earth.

    fuzzystrmatch

    1.1

    1.1

    1.1

    This extension is used to compute the similarity and distance between strings.

    ganos_address_standardizer

    5.6

    5.6

    5.6

    This extension is used to standardize the names of geographical locations based on Postal Address Geocode (PAGC). For more information, see Tuning the Standardizer.

    ganos_address_standardizer_data_us

    5.6

    5.6

    5.6

    This extension is used to standardize the names of the geographical locations in the United States based on PAGC. For more information, see Tuning the Standardizer.

    ganos_geometry

    5.6

    5.6

    5.6

    This extension is used to compute and analyze spatial geometries.

    ganos_geometry_pyramid

    5.6

    5.6

    5.6

    This extension is used to display 2D geometric big data at high speeds.

    ganos_geometry_sfcgal

    5.6

    5.6

    5.6

    This extension is an extension of the SFCGAL plug-in and is used to compute and analyze spatial geometries.

    ganos_geometry_topology

    5.6

    5.6

    5.6

    This extension is used to compute and analyze spatial geometries.

    ganos_networking

    5.6

    5.6

    5.6

    This extension is used to compute and analyze spatial network geometries.

    ganos_pointcloud

    5.6

    5.6

    5.6

    This extension is used to store, compute, and analyze point clouds.

    ganos_pointcloud_geometry

    5.6

    5.6

    5.6

    This extension is used to store, compute, and analyze point clouds.

    ganos_raster

    5.6

    5.6

    5.6

    This extension is used to store, compute, and analyze spatial rasters.

    ganos_spatialref

    5.6

    5.6

    5.6

    This extension is used to compute and analyze spatial references.

    ganos_tiger_geocoder

    5.6

    5.6

    5.6

    This extension supports the TIGER data format that is used by the USCB.

    ganos_trajectory

    5.6

    5.6

    5.6

    This extension is used to compute and analyze objects in the MOD system of Ganos.

    hll

    2.16

    2.16

    2.14

    This extension is used to estimate business metrics, such as PVs and UVs, in an efficient manner.

    hstore

    1.8

    1.8

    1.5

    This extension is used to store key-value pairs within a single PostgreSQL value.

    hypopg

    1.3.1

    1.3.1

    1.3.1

    This extension is used to create virtual indexes.

    intagg

    1.1

    1.1

    1.1

    This extension provides an integer aggregator and an enumerator.

    intarray

    1.5

    1.5

    1.2

    This extension provides functions and operators that are used to manage null-free arrays of integers.

    ip4r

    -

    2.4

    2.4

    This extension is used to store and query IPv4 and IPv6 addresses in PostgreSQL.

    isn

    1.2

    1.2

    1.2

    This extension is used to validate input numbers and hyphenate output numbers based on a hard-coded list of prefixes.

    ltree

    1.2

    1.2

    1.1

    This extension is used to label data that is stored in a hierarchical tree structure.

    mysql_fdw

    1.2

    1.2

    1.2

    This extension is used to read data from and write data to MySQL databases.

    oss_fdw

    1.1

    1.1

    1.1

    This extension is used to read data from and write data to an Object Storage Service (OSS) bucket.

    pase

    0.0.1

    0.0.1

    0.0.1

    This extension is used to search for vectors in an efficient manner.

    pg_bigm

    1.2

    1.2

    1.2

    This extension is used to create a 2-gram GIN that is used to accelerate full-text searches.

    pg_buffercache

    1.3

    1.3

    1.3

    This extension is used to examine shared buffers in real time.

    polar_concurrency_control

    -

    -

    1.0

    This extension is used to control concurrency of SQL statements.

    polar_tde_utils

    1.0

    1.0

    1.0

    This extension is used to bulk encrypt and decrypt tables and indexes by using transparent data encryption (TDE).

    pg_cron

    1.6

    1.6

    1.6

    This extension is used to configure scheduled tasks.

    pg_freespacemap

    1.2

    1.2

    1.2

    This extension is used to examine the free space map (FSM).

    pg_jieba

    1.2.0

    1.2.0

    1.1.0

    This extension is used to segment Chinese text.

    pg_pathman

    -

    -

    1.5

    This extension is used to partition tables at high performance.

    pg_hint_plan

    -

    1.4.0

    1.3.7

    This extension is used to add hints to SQL statements to modify the execution plans of SQL statements.

    pg_profile

    4.1

    4.1

    4.1

    This extension is used to collect statistics on resource-intensive activities.

    pg_repack

    1.4.8

    1.4.8

    1.4.6

    This extension is used to remove bloat from tables and indexes without significantly disrupting access to the database.

    pg_prewarm

    1.2

    1.2

    1.2

    This extension is used to load data into an operating system buffer or a PostgreSQL buffer.

    pg_sphere

    1.0

    1.0

    1.0

    This extension provides spherical data types, functions, operators, and indexes for PostgreSQL.

    pg_stat_kcache

    -

    2.2.3

    2.2.3

    This extension is used to collect statistics on read and write operations in file systems.

    pg_stat_statements

    1.9

    1.9

    1.6

    This extension is used to track the statistics of all SQL statements that are executed on a specific server.

    pg_trgm

    1.6

    1.6

    1.4

    This extension provides functions and operators that are used to compute the similarity between alphanumeric texts and index operator classes that are used to search for similar strings in an efficient manner.

    pgaudit

    -

    1.6.1

    1.3.2

    This extension is used to generate audit logs that contain details about sessions and objects.

    pgcrypto

    1.3

    1.3

    1.3

    This extension provides cryptographic functions for PostgreSQL.

    pgrouting

    3.4.2

    3.4.2

    3.4.2

    This extension is used to compute and analyze spatial network geometries.

    pgrowlocks

    1.2

    1.2

    1.2

    This extension provides a function that is used to display row lock information about a specific table.

    pgstattuple

    1.5

    1.5

    1.5

    This extension provides various functions that are used to obtain tuple-level statistics.

    pgvector

    0.4.1

    0.4.1

    N/A

    This extension is used to search for high-dimensional vector similarity.

    pldebugger

    -

    -

    1.1

    This extension is used to debug the stored procedures of a PolarDB for PostgreSQL cluster.

    plperl

    1.0

    1.0

    1.0

    This extension supports the Perl procedural language.

    plpgsql

    1.0

    1.0

    1.0

    This extension supports the SQL procedural language.

    pltcl

    1.0

    1.0

    1.0

    This extension supports the TCL procedural language.

    plv8

    N/A

    N/A

    2.3.15

    This extension is a trusted JavaScript language extension.

    postgis

    3.3.2

    3.3.2

    3.3.2

    This extension is used to manage spatial geographic information in PostGIS.

    postgis_sfcgal

    3.3.2

    3.3.2

    3.3.2

    This extension is an extension of the SFCGAL plug-in and is used to manage spatial geographic information in PostGIS.

    postgis_tiger_geocoder

    3.3.2

    3.3.2

    3.3.2

    This extension is used to manage PostGIS data in the TIGER format.

    postgis_topology

    3.3.2

    3.3.2

    3.3.2

    This extension is used to manage topological objects in PostGIS.

    q3c

    -

    -

    2.0.0

    This extension is used to create spatial indexes on a sphere.

    rdkit

    -

    -

    3.8

    This extension is used to deliver features such as molecular computing and search.

    roaringbitmap

    0.5

    0.5

    N/A

    This extension is used to compute bitmaps to increase query performance.

    RUM

    1.3

    1.3

    N/A

    This extension is used to efficiently perform full-text searches.

    sequential_uuid

    -

    1.0.2

    1.0.2

    This extension is used to generate sequential universally unique identifiers (UUIDs).

    smlar

    -

    1.0

    1.0

    This extension is used to compute the similarity between two arrays of the same data type.

    sslinfo

    1.2

    1.2

    1.2

    This extension is used to obtain information about the SSL certificate that is provided by the connected client.

    tablefunc

    1.0

    1.0

    1.0

    This extension provides functions that are used to return tables.

    tds_fdw

    -

    2.0.2

    2.0.2

    This extension allows you to query data from other types of databases.

    timescaledb

    -

    2.14.2

    2.9.2

    This extension enables automatic sharding, efficient writing and retrieval, and near-real-time aggregation of time-series data.

    tsm_system_rows

    1.0

    1.0

    1.0

    This extension provides the SYSTEM_ROWS table sampling method.

    tsm_system_time

    1.0

    1.0

    1.0

    This extension provides the SYSTEM_TIME table sampling method.

    unaccent

    1.1

    1.1

    1.1

    This extension provides a text search dictionary that is used to remove accent marks or diacritic signs from lexemes.

    uuid-ossp

    1.1

    1.1

    1.1

    This extension provides functions that use a standard algorithm to generate UUIDs.

    varbitx

    -

    -

    1.0

    This extension supports various BIT-type operations.

    wal2json

    -

    2.3

    2.2

    This extension is used to export logical log records as a file in the JSON format.

    xml2

    1.1

    1.1

    1.1

    This extension provides XPath query and XSLT functionality.

    zhparser

    1.0

    1.0

    1.0

    This extension supports full-text searches in Chinese.

    zombodb

    -

    N/A

    4.0

    This extension provides the text indexing and analytics features.