Bundled extensions ship with WarehousePG, and availability varies by version.
| Extension | Description | 6.x | 7.x |
|---|---|---|---|
amcheck | Provides functions for verifying the logical consistency of indexes and heap relations. | ✓ | — |
| auto_explain | Automatically logs execution plans of slow statements. | ✓ | ✓ |
| 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. | ✓ | ✓ |
file_fdw | Provides a foreign-data wrapper for accessing data files in the server's file system. | — | ✓ |
| fuzzystrmatch | Determines similarities and differences between strings. | ✓ | ✓ |
| gp_array_agg | Implements a parallel array_agg() aggregate function. | ✓ | — |
| gp_check_functions | Provides views to check for orphaned and missing relation files, and a function to move orphaned files. | ✓ | — |
gp_debug_numsegments | Provides functions for testing and debugging cluster segment count behavior. | — | ✓ |
gp_distribution_policy | Provides access to a table's distribution policy information. | ✓ | ✓ |
| gp_exttable_fdw | Built-in foreign-data wrapper that converts an external table to a foreign table. | — | ✓ |
gp_inject_fault | Provides fault injection points for testing cluster fault tolerance and recovery. | — | ✓ |
gp_internal_tools | Provides internal diagnostic functions for WarehousePG support and engineering use. | ✓ | ✓ |
| gp_legacy_string_agg | Implements the legacy, single-argument string_agg() aggregate function from WarehousePG 5. | ✓ | ✓ |
| gp_parallel_retrieve_cursor | Provides extended cursor functionality to retrieve data, in parallel, directly from segments. | ✓ | — |
| gp_percentile_agg | Improves GPORCA performance for ordered-set aggregate functions. | ✓ | — |
| gp_pitr | Supports point-in-time recovery for WarehousePG 6. | ✓ | — |
gp_replica_check | Provides functions for verifying consistency between primary and mirror segments. | — | ✓ |
| 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 function for querying suboverflowed backends. | ✓ | — |
gp_toolkit | Provides administrative views and functions for monitoring database status, such as skew, locks, and disk usage. | — | ✓ |
| greenplum_fdw | Foreign-data wrapper for running queries between WarehousePG clusters. | ✓ | — |
| hstore | Provides a data type for storing sets of key/value pairs within a single value. | ✓ | ✓ |
intarray | Provides additional functions, operators, and index support for arrays of integers with no null elements. | — | ✓ |
| ip4r | Provides IPv4 and IPv6 data types, range index types, and related functions and operators. | ✓ | — |
| isn | Provides data types 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 the contents of database pages. Available to superusers only. | ✓ | ✓ |
| pg_buffercache | Provides access to views for obtaining cluster-wide shared buffer metrics. | — | ✓ |
| pg_cron | Cron-based job scheduler that runs inside the database. | ✓ | — |
| pg_hint_plan | Controls the execution plan the planner chooses for a query, using hints placed in SQL comments. | — | ✓ |
| pg_stat_statements | Tracks execution statistics of all SQL statements. Requires shared_preload_libraries. | — | ✓ |
| pg_trgm | Provides functions and operators for determining the similarity of alphanumeric text based on trigram matching. | ✓ | ✓ |
| pgcrypto | Provides cryptographic functions. | ✓ | ✓ |
| PL/Perl | Enables writing functions and triggers in Perl. | ✓ | ✓ |
| PL/pgSQL | Enables writing functions, triggers, and procedural code in a SQL-like language. | ✓ | ✓ |
| PL/Python | Enables writing functions in Python. | ✓ | ✓ |
| postgres_fdw | Provides a foreign-data wrapper for accessing data stored in a remote 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 and related functions. | ✓ | — |
| tsm_system_rows | Implements the SYSTEM_ROWS table sampling method for TABLESAMPLE. | — | ✓ |
| tsm_system_time | Implements the SYSTEM_TIME table sampling method for TABLESAMPLE. | — | ✓ |
unaccent | Provides a text search dictionary that removes accents from lexemes. | — | ✓ |
| uuid-ossp | Provides functions to generate universally unique identifiers (UUIDs). | ✓ | ✓ |