Analytics Accelerator 301 Advanced techniques and optimization v1.3.2
The November 2025 Innovation Release of EDB Postgres AI is available. For more information, see the release notes.
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
- Architecture
- Apache Iceberg® advanced topics
- Delta Lake advanced topics
- Direct scan reference
- PGAA functions reference
- Functions and SQL reference
- Datasets and queries reference
- Users and permissions
- Personas: analytics by role
Next steps
Consider official training and certification: