Managing extensions in Yandex MPP Analytics for PostgreSQL

Extension

Version

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

1.0

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

1.0

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

1.1

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

1.0

dict_xsyn
Adds a dictionary template for full-text search with advanced synonym processing.

1.0

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

1.0

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

1.0

gp_array_agg
Adds a parallel implementation of the array_agg aggregate function.

1.0.0

gp_internal_tools
Contains various internal utilities.

1.0.0

gp_percentile_agg
Adds an aggregate function for calculation of percentiles.

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_sparse_vector
Adds sparse vectors and related functions.

1.0.1

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

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

1.0

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

1.0

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

1.0

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

3.7

pgaudit. Yandex Cloud extension.

Adds the ability to maintain audit logs of sessions and objects using the standard PostgreSQL logging system.

1.0.9

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

1.1

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

1.1

plperl
Enables support for the PL/Perl procedural language.

1.0

plpgsql
Enables support for the PL/pgSQL procedural language.

1.0

postgis
Enables storing and processing GIS (geographic information system) objects in PostgreSQL databases.

2.1.5

postgres_fdw
Adds a wrapper for queries against remote PostgreSQL databases.

1.0

pxf
Allows operating with heterogeneous data sources.

2.0

sslinfo
Obtains information about the connection's SSL certificate.

1.0

tablefunc
Adds table functions that return sets of rows.

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

tsearch2
Adds features compatible with the full-text search features PostgreSQL had prior to version 8.3.

1.0

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

1.0

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

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

xml2
Adds functions for XPath queries and XSLT transformations.

1.0