All Products
Search

This Product

    PolarDB:Extensions

    Document Center

    PolarDB:Extensions

    Last Updated:Jun 16, 2025

    This topic describes the extensions of PolarDB for PostgreSQL (Compatible with Oracle) and the versions of the extensions.

    Note

    • If your cluster does not support the extensions that are described in the following table, you must update the minor engine version of your cluster to the latest version. For more information, see Minor version update.

    • The following table describes only common extensions. To query the extensions that are supported by your cluster, you can execute the SELECT * FROM pg_available_extensions; statement.

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

      • The extensions involved include: pg_stat_statements, auth_delay, passwordcheck, auto_explain, pgaudit, pg_bigm, pg_cron, pg_hint_plan, pg_prewarm, zhparser, 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 Configure cluster parameters.

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

    • If exceptions occur when you install an extension and you confirm that the extension is supported by executing the SELECT * FROM pg_available_extensions; statement, contact us for assistance.

    Important

    PolarDB for PostgreSQL (Compatible with Oracle) allows you to adjust extension policies. Starting April 27, 2023, some extensions can be created only in specific minor engine versions. Existing extensions are not affected. For more information, see Some extensions cannot be created in earlier versions of PolarDB for PostgreSQL (Compatible with Oracle) as of April 27, 2023.

    Clusters that use the X86 architecture

    Extension

    PolarDB for PostgreSQL (Compatible with Oracle) 2.0

    PolarDB for PostgreSQL (Compatible with Oracle) 1.0

    Description

    address_standardizer

    3.3.7

    3.3.4

    This extension provides the address standardization service.

    address_standardizer_data_us

    3.3.7

    3.3.4

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

    bloom

    1.0

    1.0

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

    btree_gin

    1.3.1

    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

    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.5

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

    cube

    1.5

    1.4

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

    decoderbufs

    0.1.0

    0.1.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

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

    earthdistance

    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

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

    ganos_address_standardizer

    7.4

    6.8

    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

    7.4

    6.8

    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

    7.4

    6.8

    This extension is used to compute and analyze spatial geometries.

    ganos_geometry_pyramid

    7.4

    6.8

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

    ganos_geometry_sfcgal

    7.4

    6.8

    This extension is an extension of the Simple Features for Computational Geometry Algorithms Library (SFCGAL) plug-in and is used to compute and analyze spatial geometries.

    ganos_geometry_topology

    7.4

    6.8

    This extension is used to compute and analyze spatial geometries.

    ganos_networking

    7.4

    6.8

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

    ganos_pointcloud

    7.4

    6.8

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

    ganos_pointcloud_geometry

    7.4

    6.8

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

    ganos_raster

    7.4

    6.8

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

    ganos_spatialref

    7.4

    6.8

    This extension is used to compute and analyze spatial references.

    ganos_tiger_geocoder

    7.4

    6.8

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

    ganos_trajectory

    7.4

    6.8

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

    hll

    2.17

    2.17

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

    hstore

    1.8

    1.5

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

    hypopg

    1.4.0

    1.3.1

    This extension is used to create virtual indexes.

    imgsmlr

    1.0

    -

    This extension is used to search similar images.

    intagg

    1.1

    1.1

    This extension provides an integer aggregator and an enumerator.

    intarray

    1.5

    1.2

    This extension provides functions and operators that are used to manage integer arrays that do not have null values.

    isn

    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.1

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

    oss_fdw

    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

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

    pg_bigm

    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.5

    1.3

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

    pg_freespacemap

    1.2

    1.2

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

    pg_jieba

    1.1.0

    1.1.0

    This extension is used to segment Chinese text.

    pg_hint_plan

    1.4.1

    1.3.7

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

    pg_prewarm

    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

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

    pg_stat_statements

    1.9.2

    1.6

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

    pg_trgm

    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.2

    1.3.3

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

    pgcrypto

    1.3

    1.3

    This extension provides cryptographic functions for PostgreSQL.

    pgrouting

    3.4.2

    3.4.2

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

    pgrowlocks

    1.2

    1.2

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

    pgstattuple

    1.5

    1.5

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

    PGVector

    0.8.0

    0.5.0

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

    pldebugger

    1.1

    1.1

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

    plperl

    1.0

    1.0

    This extension supports the Perl procedural language.

    plpgsql

    1.0

    1.0

    This extension supports the SQL procedural language.

    pltcl

    1.0

    1.0

    This extension supports the TCL procedural language.

    postgis

    3.3.7

    3.3.4

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

    postgis_sfcgal

    3.3.7

    3.3.4

    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.7

    3.3.4

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

    postgis_topology

    3.3.7

    3.3.4

    This extension is used to manage topological objects in PostGIS.

    roaringbitmap

    0.5

    0.6

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

    RUM

    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 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

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

    tablefunc

    1.0

    1.0

    This extension provides functions that are used to return tables.

    tsm_system_rows

    1.0

    1.0

    This extension provides the SYSTEM_ROWS table sampling method.

    tsm_system_time

    1.0

    1.0

    This extension provides the SYSTEM_TIME table sampling method.

    unaccent

    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

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

    varbitx

    1.1

    1.0

    This extension supports various BIT-type operations.

    wal2json

    2.6

    2.5

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

    xml2

    1.1

    1.1

    This extension provides XPath query and XSLT functionality.

    zhparser

    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.