PolarDB:Supported extensions

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

Parses addresses into constituent elements for geocoding and address normalization.

address_standardizer_data_us

3.3.7

3.3.4

Parses and standardizes US addresses using PAGC-based rules.

bloom

1.0

1.0

Provides an index access method based on Bloom filters.

btree_gin

1.3.1

1.3

Provides GIN operator classes that implement B-tree equivalent behavior for common data types.

btree_gist

1.6.1

1.5

Provides GiST operator classes that implement B-tree equivalent behavior for common data types.

citext

1.6

1.5

Adds a case-insensitive string type.

cube

1.5

1.4

Adds a data type for representing multidimensional cubes.

decoderbufs

0.1.0

0.1.0

Generates data in Protocol Buffers (protobuf) format, compatible with the Debezium platform.

dict_int

1.0

1.0

Provides a dictionary template for full-text searches on integers.

earthdistance

1.1

1.1

Calculates great-circle distances on the Earth's surface.

fuzzystrmatch

1.1

1.1

Computes similarity and distance between strings.

ganos_address_standardizer

7.4

6.8

Standardizes geographical location names using Postal Address Geocode (PAGC) rules. See Tuning the Standardizer.

ganos_address_standardizer_data_us

7.4

6.8

Standardizes US geographical location names using PAGC rules. See Tuning the Standardizer.

ganos_geometry

7.4

6.8

Computes and analyzes spatial geometries.

ganos_geometry_pyramid

7.4

6.8

Renders 2D geometric big data at high speeds.

ganos_geometry_sfcgal

7.4

6.8

Extends Simple Features for Computational Geometry Algorithms Library (SFCGAL) for spatial geometry computation and analysis.

ganos_geometry_topology

7.4

6.8

Computes and analyzes spatial geometries.

ganos_networking

7.4

6.8

Computes and analyzes spatial network geometries.

ganos_pointcloud

7.4

6.8

Stores, computes, and analyzes point clouds.

ganos_pointcloud_geometry

7.4

6.8

Stores, computes, and analyzes point clouds.

ganos_raster

7.4

6.8

Stores, computes, and analyzes spatial rasters.

ganos_spatialref

7.4

6.8

Computes and analyzes spatial references.

ganos_tiger_geocoder

7.4

6.8

Supports the TIGER data format used by the US Census Bureau (USCB).

ganos_trajectory

7.4

6.8

Computes and analyzes objects in the Ganos Moving Object Database (MOD) system.

hll

2.17

2.17

Estimates business metrics such as page views (PVs) and unique visitors (UVs) in an efficient manner.

hstore

1.8

1.5

Stores key-value pairs within a single PostgreSQL value.

hypopg

1.4.0

1.3.1

Creates virtual indexes.

imgsmlr

1.0

-

Searches for similar images.

intagg

1.1

1.1

Provides an integer aggregator and enumerator.

intarray

1.5

1.2

Provides functions and operators for managing null-free integer arrays.

isn

1.2

1.2

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

ltree

1.2

1.1

Labels data stored in hierarchical tree structures.

oss_fdw

1.1

1.1

Reads from and writes to Object Storage Service (OSS) buckets using the foreign data wrapper (FDW) interface.

pase

0.0.1

0.0.1

Performs efficient approximate vector searches.

pg_bigm *

1.2

1.2

Creates 2-gram GIN indexes to accelerate full-text searches.

pg_buffercache

1.5

1.3

Examines shared buffers in real time.

pg_freespacemap

1.2

1.2

Examines the free space map (FSM).

pg_hint_plan *

1.4.1

1.3.7

Adds hints to SQL statements to control query execution plans.

pg_jieba *

1.1.0

1.1.0

Segments Chinese text for full-text search.

pg_prewarm *

1.2

1.2

Preloads relation data into the OS buffer cache or PostgreSQL buffer pool.

pg_sphere

1.0

1.0

Adds spherical data types, functions, operators, and indexes.

pg_stat_statements *

1.9.2

1.6

Tracks execution statistics for all SQL statements run on the server.

pg_trgm

1.6

1.4

Computes trigram-based similarity between alphanumeric strings and supports efficient similarity search indexes.

pgAudit *

1.6.2

1.3.3

Generates detailed session and object audit logs.

pgcrypto

1.3

1.3

Provides cryptographic functions for PostgreSQL.

pgrouting

3.4.2

3.4.2

Computes and analyzes spatial network geometries.

pgrowlocks

1.2

1.2

Displays row lock information for a given table.

pgstattuple

1.5

1.5

Returns tuple-level statistics for tables and indexes.

PGVector

0.8.0

0.5.0

Searches for high-dimensional vector similarity.

pldebugger *

1.1

1.1

Debugs stored procedures in PolarDB for PostgreSQL clusters.

plperl

1.0

1.0

Supports the Perl procedural language.

plpgsql

1.0

1.0

Supports the PL/pgSQL procedural language.

pltcl

1.0

1.0

Supports the Tcl procedural language.

postgis

3.3.7

3.3.4

Manages spatial geographic data in PostGIS.

postgis_sfcgal

3.3.7

3.3.4

Extends PostGIS with SFCGAL for spatial geographic information management.

postgis_tiger_geocoder

3.3.7

3.3.4

Manages PostGIS data in the TIGER format.

postgis_topology

3.3.7

3.3.4

Manages topological objects in PostGIS.

roaringbitmap

0.5

0.6

Accelerates query performance using compressed bitmap operations.

RUM

1.3

N/A

Performs efficient full-text searches using the RUM index.

sequential_uuid

1.0.2

1.0.2

Generates sequential UUIDs.

smlar

1.0

1.0

Computes similarity between two arrays of the same data type.

sslinfo

1.2

1.2

Returns information about the SSL certificate provided by the connected client.

tablefunc

1.0

1.0

Provides functions that return result sets as tables.

tsm_system_rows

1.0

1.0

Provides the SYSTEM_ROWS table sampling method.

tsm_system_time

1.0

1.0

Provides the SYSTEM_TIME table sampling method.

unaccent

1.1

1.1

Removes accent marks and diacritic signs from lexemes in full-text search.

uuid-ossp

1.1

1.1

Generates UUIDs using standard algorithms.

varbitx

1.1

1.0

Extends BIT-type operations with additional functions.

wal2json

2.6

2.5

Exports write-ahead log (WAL) records as JSON for logical decoding.

xml2

1.1

1.1

Provides XPath query and XSLT functionality.

zhparser *

1.0

1.0

Segments Chinese text for full-text search.

zombodb

N/A

4.0

Provides text indexing and analytics features.