Analytics Accelerator 301 Advanced techniques and optimization v1.3

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

• Level 201: Practical application
• Analytics Accelerator concepts
• Tiered Tables

Suggested learning path

1. Architecture
2. Apache Iceberg advanced topics
3. Delta Lake advanced topics
4. Direct scan reference
5. PGAA functions reference
6. Functions and SQL reference
7. Datasets and queries reference
8. Users and permissions
9. Personas: analytics by role

Next steps

Consider official training and certification:

• EDB Training and certification