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 U.S. data for address standardization.

AGE

-

-

1.5.1

1.5.0

1.5.0

-

A graph extension for the database. It uses 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 query tables in other 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 add-on full-text search dictionary template.

earthdistance

1.2

1.2

1.2

1.1

1.1

1.1

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

fuzzystrmatch

1.2

1.2

1.2

1.1

1.1

1.1

Determines the similarities and distances 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 U.S. data extension for toponym standardization based on the PAGC standard.

ganos_geometry

7.8

7.7

7.9

7.7

7.9

6.8

Provides computational 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 sfcgal extension features for spatial geometry.

ganos_geometry_topology

7.8

7.7

7.9

7.7

7.9

6.8

Provides computational analysis features for spatial geometry types.

ganos_networking

7.8

7.7

7.9

7.7

7.9

6.8

Provides computational analysis features for spatial geometry network types.

ganos_pointcloud

7.8

7.7

7.9

7.7

7.9

6.8

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

ganos_pointcloud_geometry

7.8

7.7

7.9

7.7

7.9

6.8

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

ganos_raster

7.8

7.7

7.9

7.7

7.9

6.8

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

ganos_spatialref

7.8

7.7

7.9

7.7

7.9

6.8

Provides computational analysis features for spatial references.

ganos_tiger_geocoder

7.8

7.7

7.9

7.7

7.9

6.8

Provides data type support for USCB TIGER data.

ganos_trajectory

7.8

7.7

7.9

7.7

7.9

6.8

Provides computational 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 within 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 for output.

ltree

1.3

1.3

1.2

1.2

1.2

1.1

Provides 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 full-text search.

pg_buffercache

1.6

1.6

1.6

1.4

1.5

1.3

Provides a way to check the shared buffer in real time.

polar_concurrency_control

-

-

1.0

-

1.0

1.0

Provides concurrency control for SQL statements.

polar_tde_utils

1.0

1.0

1.0

-

1.0

1.0

A transparent data encryption (TDE) extension for batch encryption and decryption.

pg_cron

1.5

1.5

1.5

1.5

1.5

1.2

Schedules 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

Tokenize the full Chinese text.

pg_pathman

-

-

-

-

1.5

1.5

A high-performance partitioned table extension.

pg_hint_plan

-

-

1.6.2

-

1.4.1

1.3.7

Lets you use special comment statements to change the default execution plan of PostgreSQL.

pg_profile

-

4.10

4.10

4.10

4.1

1.0

Collects 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

Collects 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 way to track execution statistics of all SQL statements executed by a 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 computational 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

An extension for high-dimensional vector similarity search.

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

This includes multiple table-returning functions.

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 can remove 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 various 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.