Reference - EDB Postgres® AI Lakehouse Innovation Release

Postgres Analytics Accelerator (PGAA) is a Postgres extension that boosts analytical query performance by replicating Postgres data to Iceberg or Delta Lake tables and then querying it with an embedded analytical engine based on Apache DataFusion.

It's built on top of Postgres, so you can use your existing Postgres knowledge and tools.

To get the best experience with Lakehouse, follow the quick start to query benchmarking data. Then you can try loading your own data and query Delta Lake tables.

This section details some of the important things to know:

• Benchmarking datasets
• Queries in Lakehouse
• Delta Table tools
• DirectScan and fallback modes
• Users
• Loading data
• Functions

For information on the PGFS functions for managing storage location, see the AI Factory PGFS documentation.