Managing extensions in Yandex MPP Analytics for PostgreSQL

Extension

Version for Greenplum®

Version for Apache Cloudberry™

bool_plperl
Provides transformation for the bool type for the PL/Perl procedural language.

—

1.0

btree_gist
Provides GiST operator classes with behavior similar to B-tree.

—

1.6

btree_gin
Adds the ability to create GIN indexes for columns suitable for B-tree indexing.

1.0

1.3

citext
Adds a data type for case-insensitive string comparison.

1.0

1.6

dblink
Enables support for connections to other Greenplum® databases within a session.

1.1

1.2

dict_int
Adds a dictionary template for full-text search for integers.

1.0

1.0

diskquota
Allows limiting the of disk space for schemas and roles in a database.

1.0

2.3

fuzzystrmatch
Contains functions used to establish the degree of similarity and distance between any two strings.

1.0

1.1

gp_distribution_policy
Contains information about the table data distribution policy across cluster segments.

1.0

1.0

gp_exttable_fdw
Provides an external data wrapper for working with external tables.

—

1.0

gp_internal_tools
Contains various internal utilities.

1.0.0

1.0.0

gp_relaccess_stats. Yandex Cloud extension

Collects the access statistics for tables and views. For more information, see Using gp_relaccess_stats.

1.1

—

gp_relsizes_stats. Yandex Cloud extension

Collects file and table size statistics. For more information, see Using gp_relsizes_stats.

1.0

—

gp_toolkit
Provides a number of administrative views and functions.

—

1.6

gp_url_tools. Yandex Cloud extension

Contains functions for working with URLs. For more information, see Using gp_url_tools.

1.0

—

hstore
Adds a data type to store key-value pairs in the same field.

1.3

1.8

intarray
Adds functions, operators, and index support for one-dimensional arrays of integers.

1.0

1.5

isn
Adds a data type for working with international product identification standards.

1.0

1.2

jsonb_plperl
Provides transformation for the jsonb type for the PL/Perl procedural language.

—

1.0

logerrors
Adds a function for collecting statistics about log messages.

2.1

2.1

ltree
Adds a data type to represent data labels in a tree hierarchy.

1.0

1.2

orafce
Adds functions and operators that emulate Oracle functions and packages.

3.7

4.9

pgcrypto
Adds data encryption features. For more information, see Using pgcrypto.

1.1

1.3

pg_trgm
Adds functions and operators for text similarity detection and indexing operators to search for similar strings.

1.1

1.6

plperl
Enables support for the PL/Perl procedural language.

1.0

1.0

plpgsql
Enables support for the PL/pgSQL procedural language.

1.0

1.0

postgres_fdw
Adds a wrapper for queries against remote PostgreSQL databases.

1.0

1.1

pxf
Allows operating with heterogeneous data sources.

2.0

2.1

pxf_fdw
Adds an external data wrapper for accessing heterogeneous data sources.

—

2.0

seg
Adds a data type for representing intervals or ranges with floating points.

1.0

1.4

tablefunc
Adds table functions that return sets of rows.

1.0

1.0

tcn
Adds a trigger function to notify subscribers about changes in tables.

1.0

1.0

try_convert. Yandex Cloud extension.

Adds a function to convert data from one type to another. For more information, see Using try_convert.

1.0

—

tsm_system_rows
Provides the SYSTEM_ROWS table sampling method.

—

1.0

tsm_system_time
Provides the SYSTEM_TIME table sampling method.

—

1.0

unaccent
Adds a full-text search dictionary that removes diacritics.

1.0

1.1

uuid-cb. Yandex Cloud extension.

Enables the generation and validation of unique IDs in compliance with the Russian Central Bank requirements. For more information, see Using uuid-cb.

1.0

—

uuid-ossp
Provides functions for generating universally unique identifiers (UUIDs).

—

1.1

yezzey. Yandex Cloud extension.

Enables moving AO and AOCO tables from cluster storage to cold storage and vice versa. To use this extension, enable hybrid storage in your Yandex MPP Analytics for PostgreSQL cluster.

1.8

1.8.8

xml2
Adds functions for XPath queries and XSLT transformations.

1.0

1.1