Additional Supplied Modules

WarehousePG (WHPG) extends the core capabilities of Postgres with a suite of additional modules designed for enterprise-scale data warehousing. These modules provide specialized functionality for performance, security, and integration, and are categorized into three primary types:

• Postgres Sourced Modules: These are standard "contrib" modules that are part of the official PostgreSQL distribution. WarehousePG includes these to ensure developers can use familiar, high-quality Postgres tools for data manipulation and query analysis.

• WHPG Open Source Modules: These are open-source extensions specifically developed or optimized for the WarehousePG MPP ecosystem.

• EDB Provided Modules: These are specialized enhancements provided by EDB to deliver enterprise-grade security, governance, and support for business-critical environments.

The following WarehousePG and PostgreSQL contrib modules are installed; refer to the linked module documentation for usage instructions.

• auto_explain Provides a means for logging execution plans of slow statements automatically.
• btree_gin - Provides sample generalized inverted index (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 WarehousePGs.
• diskquota - Allows administrators to set disk usage quotas for WarehousePG roles and schemas.
• fuzzystrmatch - Determines similarities and differences between strings.
• gp_exttable_fdw - Built-in foreign-data wrapper that internally converts an external table to a foreign table.
• gp_legacy_string_agg - Implements a legacy, single-argument string_agg() aggregate function that was present in WarehousePG 5.
• gp_sparse_vector - Implements a WarehousePG data type that uses compressed storage of zeros to make vector computations on floating point numbers faster.
• hstore - Provides a data type for storing sets of key/value pairs within a single PostgreSQL value.
• ip4r - Provides data types for operations on IPv4 and IPv6 IP addresses.
• ltree - Provides data types for representing labels of data stored in a hierarchical tree-like structure.
• orafce - Provides WarehousePG-specific 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 five views for obtaining cluster-wide shared buffer metrics.
• 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. The module also provides index operator classes that support fast searching for similar strings.
• pgcrypto - Provides cryptographic functions for WarehousePG.
• postgresml - Provides functions for using tens of thousands of pre-trained open source AI/machine learning models in WarehousePG.
• postgres_fdw - Provides a foreign data wrapper (FDW) for accessing data stored in an external PostgreSQL or WarehousePG.
• postgresql-hll - Provides HyperLogLog data types for PostgreSQL and WarehousePG.
• sslinfo - Provides information about the SSL certificate that the current client provided when connecting to WarehousePG.
• tablefunc - Provides various functions that return tables (multiple rows).
• timestamp9 - Provides an efficient nanosecond-precision timestamp data type for WarehousePG.
• tsm_system_rows - Implements the SYSTEM_ROWS table sampling method.
• tsm_system_time - implements the SYSTEM_TIME table sampling method.
• uuid-ossp - Provides functions to generate universally unique identifiers (UUIDs).