Hybrid Manager (HM) includes Postgres Analytics Accelerator (PGAA), a high-performance extension that enables Postgres to query large-scale data stored in open table formats like Delta Lake, Apache Iceberg, and Parquet.
For concepts, architecture, and reference documentation, see the PGAA documentation.
PGAA is available on two cluster types in HM:
- Advanced High Availability (AHA) and Distributed High Availability (DHA) clusters — EDB Postgres Distributed (PGD)-based cluster types that support data tiering and analytics. Catalog and storage configuration are done directly in your database client using PGAA and PGD functions. See Using tiered storage in the PGD documentation for implementation details.
- Lakehouse clusters — Dedicated analytical compute nodes with PGAA pre-installed for querying object storage using standard Postgres SQL. The HM console provisions and connects to Lakehouse clusters, but catalog and storage configuration is done directly in your database client. See Lakehouse clusters.
Lakehouse clusters
Lakehouse clusters are HM-managed Postgres nodes with PGAA pre-installed, dedicated to querying Apache Iceberg®, Delta Lake, and Parquet files in object storage using standard Postgres SQL. The pgaa and pgfs extensions are pre-installed and ready to use. Catalog attachment and storage configuration are done directly in your database client using PGAA functions.
To create and manage Lakehouse clusters, see Lakehouse clusters.