Postgres Analytics Accelerator (PGAA)#
Postgres Analytics Accelerator (PGAA) is a high-performance extension that enables Postgres to query large-scale data stored in open table formats like Delta Lake, Apache Iceberg, and Parquet. By offloading heavy analytical queries to a vectorized execution engine, PGAA bridges the gap between operational databases and data lakes.
- Get started
- Analytics Accelerator 1.7 release notes
- Analytics Accelerator
- Installing Analytics Accelerator
- Configuring storage locations
- Reading tables in object storage
- Integrating with Iceberg catalogs
- Writing to object storage
- Replicating with PGD
- Accelerating with Spark
- Monitoring and maintaining analytical tables
- Optimizing query performance
- Reference