PolarDB:Extensions

Extension

PostgreSQL 16

PostgreSQL 15

PostgreSQL 14

PostgreSQL 11

Description

address_standardizer

3.3.7

3.3.7

3.3.7

3.3.4

Provides the address standardization service.

address_standardizer_data_us

3.3.7

3.3.7

3.3.7

3.3.4

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

AGE

1.5.0

1.5.0

1.5.0

-

Allows you to query graphs in a database by using Cypher.

bloom

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

1.3

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

btree_gist

1.7

1.7

1.6.1

1.5

Provides sample GiST operator classes used to implement B-tree equivalent behavior for multiple data types or all enumerated data types.

citext

1.6

1.6

1.6

1.5

Provides a case-insensitive string type.

cube

1.5

1.5

1.5

1.4

Provides a data type used to represent multidimensional cubes.

dblink

1.2

1.2

1.2

1.2

Manages tables across databases.

decoderbufs

-

-

0.1.0

0.1.0

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

dict_int

1.0

1.0

1.0

1.0

Provides a sample add-on dictionary template used to perform full-text searches.

earthdistance

1.2

1.1

1.1

1.1

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

fuzzystrmatch

1.2

1.1

1.1

1.1

Computes the similarity and distance between strings.

ganos_address_standardizer

7.4

7.4

7.4

6.8

Standardizes the names of geographical locations based on Postal Address Geocode (PAGC).

ganos_address_standardizer_data_us

7.4

7.4

7.4

6.8

Standardizes the names of the geographical locations in the United States based on PAGC.

ganos_geometry

7.4

7.4

7.4

6.8

Computes and analyzes spatial geometries.

ganos_geometry_pyramid

7.4

7.4

7.4

6.8

Displays 2D geometric big data at high speeds.

ganos_geometry_sfcgal

7.4

7.4

7.4

6.8

Provides advanced spatial geometry functionalities by integrating the SFCGAL extension.

ganos_geometry_topology

7.4

7.4

7.4

6.8

Computes and analyzes spatial geometries.

ganos_networking

7.4

7.4

7.4

6.8

Computes and analyzes spatial network geometries.

ganos_pointcloud

7.4

7.4

7.4

6.8

Stores, computes, and analyzes point clouds.

ganos_pointcloud_geometry

7.4

7.4

7.4

6.8

Stores, computes, and analyzes point clouds within a geospatial database environment.

ganos_raster

7.4

7.4

7.4

6.8

Stores, computes, and analyzes spatial rasters.

ganos_spatialref

7.4

7.4

7.4

6.8

Computes and analyzes spatial references.

ganos_tiger_geocoder

7.4

7.4

7.4

6.8

Supports the TIGER data format used by the USCB.

ganos_trajectory

7.4

7.4

7.4

6.8

Computes and analyzes objects in the MOD system of Ganos.

hll

2.18

2.18

2.17

2.17

Estimates business metrics, such as PVs and UVs, in an efficient manner.

hstore

1.8

1.8

1.8

1.5

Stores key-value pairs within a single PostgreSQL value.

hypopg

-

1.3.1

1.4.0

1.3.1

Creates virtual indexes.

imgsmlr

-

-

1.0

-

Provides image similarity search.

intagg

1.1

1.1

1.1

1.1

Provides an integer aggregator and an enumerator.

intarray

1.5

1.5

1.5

1.2

Provides functions and operators that are used to manage null-free arrays of integers.

ip4r

-

-

2.4

2.4

Stores and queries IPv4 and IPv6 addresses in PostgreSQL.

isn

1.2

1.2

1.2

1.2

Validates input numbers and hyphenate output numbers based on a hard-coded list of prefixes.

ltree

1.2

1.2

1.2

1.1

Labels data that is stored in a hierarchical tree structure.

mysql_fdw

1.2

1.2

1.2

1.1

Reads data from and writes data to MySQL databases.

oss_fdw

1.1

-

1.1

1.1

Reads data from and writes data to an Object Storage Service (OSS) bucket.

pase

0.0.1

0.0.1

0.0.1

0.0.1

Searches for vectors in an efficient manner.

pg_bigm

1.2

1.2

1.2

1.2

Creates a 2-gram GIN that is used to accelerate full-text searches.

pg_buffercache

1.5

1.4

1.5

1.3

Examines shared buffers in real time.

polar_concurrency_control

-

-

-

1.0

Controls concurrency of SQL statements.

polar_tde_utils

1.0

-

1.0

1.0

Bulk encrypts and decrypts tables and indexes by using transparent data encryption (TDE).

pg_cron

1.5

1.5

1.5

1.2

Configures scheduled tasks.

pg_freespacemap

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

Segments Chinese text.

pg_pathman

-

-

1.5

1.5

Partitiones tables at high performance.

pg_hint_plan

1.6.1

-

1.4.1

1.3.7

Adds hints to SQL statements to modify the execution plans of SQL statements.

pg_profile

-

-

4.1

-

Collect statistics on resource-intensive activities.

pg_prewarm

1.2

1.2

1.2

1.2

Loads data into an operating system buffer or a PostgreSQL buffer.

pg_sphere

1.0

-

1.0

1.0

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

pg_stat_kcache

-

-

2.2.1

2.2.1

Collect statistics on read and write operations in file systems.

pg_stat_statements

1.10

1.10

1.9.2

1.6

Tracks the statistics of all SQL statements that are executed on a specific server.

pg_trgm

1.6

1.6

1.6

1.4

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

Generates audit logs that contain details about sessions and objects.

pgcrypto

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

Provides geospatial routing and network analysis.

pgrowlocks

1.2

1.2

1.2

1.2

Provides a function used to display row lock information about a specific table.

pgstattuple

1.5

1.5

1.5

1.5

Provides various functions that are used to obtain tuple-level statistics.

pgvector

0.8.0

0.8.0

0.8.0

0.5.0

Searches for high-dimensional vector similarity.

pldebugger

1.1

1.1

1.1

1.1

Debugs the stored procedures of a PolarDB for PostgreSQL cluster.

plperl

1.0

1.0

1.0

1.0

Supports the Perl procedural language.

plpgsql

1.0

1.0

1.0

1.0

Supports the SQL procedural language.

pltcl

1.0

1.0

1.0

1.0

Supports the TCL procedural language.

postgis

3.3.7

3.3.7

3.3.7

3.3.4

Manages spatial geographic information in PostGIS.

postgis_sfcgal

3.3.7

3.3.7

3.3.7

3.3.4

Provides advanced 3D geometry operations.

postgis_tiger_geocoder

3.3.7

3.3.7

3.3.7

3.3.4

Provides geocoding and reverse geocoding.

postgis_topology

3.3.7

3.3.7

3.3.7

3.3.4

Models spatial relationships between geometries.

q3c

-

-

-

2.0.0

Creates spatial indexes on a sphere.

rdkit

-

-

-

3.8

Delivers features such as molecular computing and search.

roaringbitmap

0.5

0.5

0.5

0.5

Computes bitmaps to increase query performance.

rum

1.3

1.3

1.3

-

Provides high-speed full-text searches.

sequential_uuid

-

-

1.0.2

1.0.2

Generates sequential universally unique identifiers (UUIDs).

smlar

1.0

-

1.0

1.0

Computes the similarity between two arrays of the same data type.

sslinfo

1.2

1.2

1.2

1.2

Obtains information about the SSL certificate that is provided by the connected client.

tablefunc

1.0

1.0

1.0

1.0

Provides functions that are used to return tables.

tds_fdw

-

-

2.0.2

2.0.2

Allows you to query data from other types of databases.

timescaledb

2.18.0

-

2.16.1

1.7.1

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

1.0

Provides the SYSTEM_ROWS table sampling method.

tsm_system_time

1.0

1.0

1.0

1.0

Provides the SYSTEM_TIME table sampling method.

unaccent

1.1

1.1

1.1

1.1

Provides a text search dictionary used to remove accent marks or diacritic signs from lexemes.

uuid-ossp

1.1

1.1

1.1

1.1

Provides functions that use a standard algorithm to generate UUIDs.

varbitx

1.1

1.1

1.1

1.1

Supports various BIT-type operations.

wal2json

2.6

2.6

2.6

2.5

Exports logical log records as a file in the JSON format.

xml2

1.1

1.1

1.1

1.1

Provides XPath query and XSLT functionality.

zhparser

2.2

2.2

1.0

1.0

Supports full-text searches in Chinese.

zombodb

-

-

-

4.0

Provides the text indexing and analytics features.