Analytics Accelerator 301 Advanced techniques and optimization

Analytics Accelerator 301 Advanced techniques and optimization#

For experienced users, architects, and engineers ready to deepen their expertise with advanced optimization and architecture patterns.

What you will learn#

  • Advanced configuration of EDB Postgres Lakehouse, PGAA, and PGFS

  • Performance tuning for vectorized queries and object storage access

  • Complex tiered table strategies for optimized cost and performance

  • Managing advanced Iceberg catalogs and integrating third-party catalogs

  • Architecting solutions that combine Analytics Accelerator with other data frameworks (Spark, streaming platforms)

  • Troubleshooting complex analytical queries and data pipelines

  • Security best practices for analytics environments

Before you begin#

Suggested learning path#

  1. Analytics Accelerator Architecture

  2. Apache Iceberg Integration With Analytics Accelerator

  3. Delta Lake Integration with Analytics Accelerator

  4. DirectScan and fallback modes

  5. PGAA functions reference

  6. PGAA functions reference

  7. Benchmarking datasets

  8. User management

  9. Analytics Accelerator for your role a persona-based guide

Next steps#

Consider official training and certification:

Contents