Managing extensions in Yandex MPP Analytics for PostgreSQL

Extension

Version for Greenplum®

Version for Apache Cloudberry™

autoinc
Adds a trigger function to write the next value from a sequence into an integer field.

1.0

1.0

amcheck
Contains functions for verifying the logical integrity of index structures.

1.0

1.3

bloom
Provides an index access method based on the Bloom filter.

—

1.0

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

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

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_array_agg
Adds a parallel implementation of the array_agg aggregate function.

1.0.0

—

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

1.0

1.0

gp_debug_numsegments
Provides functions for getting and setting the default number of segments when creating tables.

—

1.0

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

—

1.0

gp_inject_fault
Provides an interface for implementing predefined failure points in a running cluster.

—

1.0

gp_internal_tools
Contains various internal utilities.

1.0.0

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

1.0.1

gp_stats_collector
Provides tools for collecting query execution metrics and forwarding them to an external agent.

1.1

1.1

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

hstore_plperl
Provides transformation for the hstore type for the PL/Perl procedural language.

—

1.0

insert_username
Adds a trigger function to write the current user name into a text field.

1.0

1.0

intagg. This extension is deprecated.
Adds an integer aggregator and enumerator.

—

1.1

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

moddatetime
Adds a trigger function to write the current time into the timestamp field.

1.0

1.0

old_snapshot
Enables analysis of the old_snapshot_threshold state.

—

1.0

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

3.7

4.9

pageinspect
Provides functions for low-level analysis of database page contents.

1.8

1.9

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

1.3

pgrowlocks
Provides a function for viewing table row lock details.

1.1

1.2

pgstattuple
Provides functions for retrieving tuple-level statistics.

1.2

1.5

pg_buffercache
Provides tools for real-time analysis of the shared buffer cache contents.

1.1

1.4.1

pg_freespacemap
Provides tools for analyzing the free space map (FSM).

1.0

1.2

pg_hint_plan
Enables management of query execution plans using hints in SQL comments.

—

1.3.9

pg_prewarm
Provides a way to load relation data into the operating system cache or the PostgreSQL buffer cache.

1.0

1.2

pg_stat_statements
Provides tools to track planning and execution statistics for SQL statements.

1.2

1.9

pg_surgery
Provides functions for repairing corrupted relations.

—

1.0

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

1.1

1.6

pg_visibility
Provides tools for analyzing the visibility map and information about relation page visibility.

—

1.2

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

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

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

refint
Adds trigger functions for implementing referential integrity.

1.0

1.0

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

1.0

1.4

sslinfo
Obtains information about the connection's SSL certificate.

1.0

1.2

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

—

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

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