These modules ship with WarehousePG. Activate them in each database with CREATE EXTENSION <module_name>, unless the individual reference page specifies a different activation method.

• auto_explain - Logs execution plans of slow statements automatically.
• btree_gin - Provides GIN operator classes that implement B-tree equivalent behavior for certain data types.
• citext - Provides a case-insensitive, multibyte-aware text data type.
• dblink - Provides connections to other WarehousePG databases.
• fuzzystrmatch - Determines similarities and differences between strings.
• gp_array_agg - Implements a parallel array_agg() aggregate function for WarehousePG.
• gp_check_functions - Provides views to check for orphaned and missing relation files and a user-defined function to move orphaned files.
• gp_legacy_string_agg - Implements a legacy, single-argument string_agg() aggregate function that was present in WarehousePG 5.
• gp_parallel_retrieve_cursor - Provides extended cursor functionality to retrieve data, in parallel, directly from WarehousePG segments.
• gp_percentile_agg - Improves GPORCA performance for ordered-set aggregate functions.
• gp_pitr - Supports implementing point-in-time recovery for WarehousePG 6.
• gp_sparse_vector - Implements a data type that uses compressed storage of zeros to make vector computations on floating point numbers faster.
• gp_subtransaction_overflow - Provides a view and user-defined function for querying suboverflowed backends.
• greenplum_fdw - Provides a foreign data wrapper for accessing data stored in one or more external WarehousePG clusters.
• hstore - Provides a data type for storing sets of key/value pairs within a single value.
• ip4r - Provides data types for operations on IPv4 and IPv6 IP addresses.
• isn - Provides support for international product numbering standards (EAN13, UPC, ISBN, ISMN, ISSN).
• ltree - Provides data types for representing labels of data stored in a hierarchical tree-like structure.
• orafce - Provides Oracle SQL compatibility functions.
• pageinspect - Provides functions for low-level inspection of database page contents. Available to superusers only.
• pg_cron - Provides a cron-based job scheduler that runs inside the database.
• pg_trgm - Provides functions and operators for determining the similarity of alphanumeric text based on trigram matching.
• pgcrypto - Provides cryptographic functions.
• postgres_fdw - Provides a foreign data wrapper for accessing data stored in an external PostgreSQL or WarehousePG database.
• sslinfo - Provides information about the SSL certificate of the current client connection.
• tablefunc - Provides various functions that return tables (multiple rows).
• timestamp9 - Provides an efficient nanosecond-precision timestamp data type.
• uuid-ossp - Provides functions to generate universally unique identifiers (UUIDs).