Analytics Accelerator v1.6

Suggest edits

The Postgres Analytics Accelerator (PGAA) transforms Postgres into a high-performance analytical engine. By integrating vectorized execution and open table formats, PGAA allows you to run complex OLAP queries directly on your data lake without leaving the Postgres ecosystem.

Use the following resources to understand the foundation of the accelerator and prepare your environment for production workloads.

  • Quickstart guide: A step-by-step guide to install PGAA, create a storage location and read a table from our sample benchmark datasets.

  • Architecture: A deep dive into the decoupled compute and storage model. Learn how the PGAA extension interacts with Seafowl (the vectorized engine), and object storage providers like S3, GCS, and Azure Data Lake Storage.

  • Core concepts: Explore the fundamental principles of PGAA, including vectorized execution, columnar storage, and the difference between the DirectScan and CompatScan execution paths.

  • Compatibility: A detailed matrix of supported Postgres versions, operating systems, and cloud provider availability.

  • Known Issues: A transparent list of current limitations, unsupported cases, and active bugs we are currently addressing.

← Prev

Analytics Accelerator 1.6 release notes

↑ Up

Postgres Analytics Accelerator (PGAA)

Next →

Analytics Accelerator quickstart guide