Analytics Accelerator 301 Advanced techniques and optimization Innovation Release
This documentation covers the current Innovation Release of
EDB Postgres AI. You may also want the docs for the current LTS version.
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
- Functions reference
- Datasets and queries reference
- Users and permissions
- Personas: analytics by role
Next steps
Consider official training and certification: