PolarDB:Supported extensions

Extension name

PostgreSQL 18

PostgreSQL 17

PostgreSQL 16

PostgreSQL 15

PostgreSQL 14

PostgreSQL 11

Description

address_standardizer

3.3.7

3.3.7

3.3.7

3.3.7

3.3.7

3.3.4

Provides address standardization.

address_standardizer_data_us

3.3.7

3.3.7

3.3.7

3.3.7

3.3.7

3.3.4

Provides address standardization data for the United States.

AGE

-

-

1.5.1

1.5.0

1.5.0

-

A graph extension for databases. Use the Cypher language to query graphs in the database.

bloom

1.0

1.0

1.0

1.0

1.0

1.0

Provides an index access method based on Bloom filters.

btree_gin

1.3

1.3

1.3

1.3

1.3.1

1.3

Provides a sample GIN operator class that implements B-tree equivalent behavior for multiple data types and all enum types.

btree_gist

1.8

1.7

1.7

1.7

1.6.1

1.5

Provides a sample GiST operator class that implements B-tree equivalent behavior for multiple data types and all enum types.

citext

1.8

1.6

1.6

1.6

1.6

1.5

Provides a case-insensitive string type.

cube

1.5

1.5

1.5

1.5

1.5

1.4

Provides a data type to represent multidimensional cubes.

dblink

1.2

1.2

1.2

1.2

1.2

1.2

Lets you perform operations on tables across databases.

decoderbufs

0.1.0

0.1.0

0.1.0

0.1.0

0.1.0

0.1.0

Outputs data that is compatible with the Debezium platform based on the Protocol Buffers protocol.

dict_int

1.0

1.0

1.0

1.0

1.0

1.0

A sample text search dictionary template.

earthdistance

1.2

1.2

1.2

1.1

1.1

1.1

Provides two different methods to calculate the great-circle distance on the surface of the Earth.

fuzzystrmatch

1.2

1.2

1.2

1.1

1.1

1.1

Determines the similarities and distance between strings.

ganos_address_standardizer

7.8

7.7

7.9

7.7

7.9

6.8

A toponym standardization extension based on the PAGC standard.

ganos_address_standardizer_data_us

7.8

7.7

7.9

7.7

7.9

6.8

A toponym standardization extension for data in the United States based on the PAGC standard.

ganos_geometry

7.8

7.7

7.9

7.7

7.9

6.8

Provides computing and analysis features for spatial geometry types.

ganos_geometry_pyramid

7.8

7.7

7.9

7.7

7.9

6.8

Used for fast display of 2D spatial geometry big data.

ganos_geometry_sfcgal

7.8

7.7

7.9

7.7

7.9

6.8

Provides extension features for the sfcgal spatial geometry extension.

ganos_geometry_topology

7.8

7.7

7.9

7.7

7.9

6.8

Provides computing and analysis features for spatial geometry types.

ganos_networking

7.8

7.7

7.9

7.7

7.9

6.8

Provides computing and analysis features for spatial geometry network types.

ganos_pointcloud

7.8

7.7

7.9

7.7

7.9

6.8

Provides storage, computing, and analysis features for point clouds.

ganos_pointcloud_geometry

7.8

7.7

7.9

7.7

7.9

6.8

Provides storage, computing, and analysis features for point clouds.

ganos_raster

7.8

7.7

7.9

7.7

7.9

6.8

Provides storage, computing, and analysis features for spatial raster data.

ganos_spatialref

7.8

7.7

7.9

7.7

7.9

6.8

Provides computing and analysis features for spatial references.

ganos_tiger_geocoder

7.8

7.7

7.9

7.7

7.9

6.8

Provides support for the USCB TIGER data type.

ganos_trajectory

7.8

7.7

7.9

7.7

7.9

6.8

Provides computing and analysis features for Ganos moving object data (MOD).

hll

2.18

2.18

2.18

2.18

2.17

2.17

Quickly estimates business metrics such as page views (PVs) and unique visitors (UVs).

hstore

1.8

1.8

1.8

1.8

1.8

1.5

Stores key-value pairs in a single PostgreSQL value.

hypopg

1.4.0

-

1.4.0

1.3.1

1.4.0

1.3.1

Creates hypothetical indexes.

imgsmlr

-

-

1.0

-

1.0

-

Supports similar image search.

intagg

1.1

1.1

1.1

1.1

1.1

1.1

Provides an integer aggregator and an enumerator.

intarray

1.5

1.5

1.5

1.5

1.5

1.2

Provides useful functions and operators to manipulate integer arrays that do not contain null values.

ip4r

2.4

2.4

2.4

2.4

2.4

2.4

Enables PostgreSQL to support IP address range types.

isn

1.3

1.2

1.2

1.2

1.2

1.2

Validates input against a hard-coded prefix list and is also used to concatenate numbers on output.

ltree

1.3

1.3

1.2

1.2

1.2

1.1

Represents labels for data stored in a hierarchical tree-like structure.

mysql_fdw

1.2

1.2

1.2

1.2

1.2

1.1

Reads and writes data in MySQL databases.

oss_fdw

-

-

1.1

-

1.1

1.1

Reads and writes data in OSS.

pase

0.0.1

0.0.1

0.0.1

0.0.1

0.0.1

0.0.1

Provides efficient vector retrieval.

pg_bigm

1.2

1.2

1.2

1.2

1.2

1.2

Creates a 2-gram GIN index to accelerate the full-text search process.

pg_buffercache

1.6

1.6

1.6

1.4

1.5

1.3

Provides a method to inspect the shared buffer in real time.

polar_concurrency_control

-

-

1.0

-

1.0

1.0

Used for concurrency control of SQL statements.

polar_tde_utils

1.0

1.0

1.0

-

1.0

1.0

A TDE extension for batch encryption and decryption.

pg_cron

1.5

1.5

1.5

1.5

1.5

1.2

Lets you set scheduled tasks.

pg_freespacemap

1.3

1.2

1.2

1.2

1.2

1.2

Examines the free space map (FSM).

pg_jieba

1.1.0

1.1.0

1.1.0

1.1.0

1.1.0

1.1.0

Provides tokenization for Chinese full-text search.

pg_pathman

-

-

-

-

1.5

1.5

A high-performance partitioned table extension.

pg_hint_plan

-

-

1.6.2

-

1.4.1

1.3.7

Allows PostgreSQL to change its execution plan based on hints in special comments.

pg_profile

-

4.1

4.1

4.1

4.1

1.0

Gathers statistics on resource-intensive activities.

pg_prewarm

1.2

1.2

1.2

1.2

1.2

1.2

Provides a convenient way to load data into the operating system buffer or the PostgreSQL buffer.

pg_sphere

-

-

1.0

-

1.0

1.0

Provides spherical data types, functions, operators, and indexes for PostgreSQL.

pg_stat_kcache

2.3.1

2.3.0

2.3.0

2.3.0

2.2.1

2.2.1

Gathers statistics on system read and write information.

pg_stat_statements

1.12

1.11

1.10.1

1.10

1.9.2

1.6

Provides a method to track execution statistics of all SQL statements executed by the server.

pg_trgm

1.6

1.6

1.6

1.6

1.6

1.4

Provides functions and operators to determine the similarity of alphanumeric text, and index operator classes that support fast searches for similar strings.

pgaudit

18.1

17.1

16.1

1.7.1

1.6.2

1.3.3

Provides detailed session and object audit logging.

pgcrypto

1.4

1.3

1.3

1.3

1.3

1.3

Provides cryptographic functions for PostgreSQL.

pgrouting

3.4.2

3.4.2

3.4.2

3.4.2

3.4.2

3.4.2

Provides computing and analysis features for spatial geometry networks.

pgrowlocks

1.2

1.2

1.2

1.2

1.2

1.2

Provides a function to display row lock information for a specified table.

pgstattuple

1.5

1.5

1.5

1.5

1.5

1.5

Provides various functions to obtain tuple-level statistics.

pgvector

0.8.0

0.8.0

0.8.0

0.8.0

0.8.0

0.5.0

A high-dimensional vector similarity search extension.

pldebugger

1.1

1.1

1.1

1.1

1.1

1.1

A stored procedure debugger extension.

plperl

1.0

1.0

1.0

1.0

1.0

1.0

Provides the Perl procedural language.

plpgsql

1.0

1.0

1.0

1.0

1.0

1.0

Provides the SQL procedural language.

pltcl

1.0

1.0

1.0

1.0

1.0

1.0

Provides the Tcl procedural language.

postgis

3.3.7

3.3.7

3.3.7

3.3.7

3.3.7

3.3.4

PostGIS extensions for spatial and geographic information.

postgis_sfcgal

3.3.7

3.3.7

3.3.7

3.3.7

3.3.7

3.3.4

PostGIS SFCGAL extensions for spatial and geographic information.

postgis_tiger_geocoder

3.3.7

3.3.7

3.3.7

3.3.7

3.3.7

3.3.4

PostGIS TIGER data extensions for spatial and geographic information.

postgis_topology

3.3.7

3.3.7

3.3.7

3.3.7

3.3.7

3.3.4

PostGIS topology data extensions for spatial and geographic information.

q3c

-

-

-

-

-

2.0.0

Used for spatial indexing on a sphere.

rdkit

-

-

-

-

-

3.8

Supports features such as cheminformatics and chemical molecule retrieval.

roaringbitmap

0.5

0.5

0.5

0.5

0.5

0.5

Uses bitmap to improve query performance.

rum

-

1.3

1.3

1.3

1.3

-

Provides high-speed full-text search.

sequential_uuid

1.0.3

1.0.3

1.0.3

1.0.3

1.0.2

1.0.2

A UUID generator with a sequential pattern.

smlar

-

-

1.0

-

1.0

1.0

Calculates the similarity between two arrays of the same type.

sslinfo

1.2

1.2

1.2

1.2

1.2

1.2

Provides information about the SSL certificate provided by the current client.

tablefunc

1.0

1.0

1.0

1.0

1.0

1.0

Includes multiple functions that return tables.

tds_fdw

-

-

-

-

2.0.2

2.0.2

Queries data from other types of databases.

timescaledb

-

-

2.18.0

-

2.16.1

1.7.1

Supports automatic sharding, efficient writes, retrieval, and near-real-time aggregation for time series data.

tsm_system_rows

1.0

1.0

1.0

1.0

1.0

1.0

Provides the SYSTEM_ROWS table sampling method.

tsm_system_time

1.0

1.0

1.0

1.0

1.0

1.0

Provides the SYSTEM_TIME table sampling method.

unaccent

1.1

1.1

1.1

1.1

1.1

1.1

A text search dictionary that removes accents (diacritical marks) from lexemes.

uuid-ossp

1.1

1.1

1.1

1.1

1.1

1.1

Provides functions to generate universally unique identifiers (UUIDs) using one of several standard algorithms.

varbitx

1.1

1.1

1.1

1.1

1.1

1.1

Supports multiple BIT operations.

wal2json

2.6

2.6

2.6

2.6

2.6

2.5

Outputs logical log files in JSON format.

xml2

1.2

1.1

1.1

1.1

1.1

1.1

Provides XPath query and XSLT features.

zhparser

2.2

2.2

2.2

2.2

1.0

1.0

Provides Chinese full-text search.

zombodb

-

-

-

-

-

4.0

Provides powerful text indexing and analysis features.