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

• Analytics Accelerator concepts

Suggested learning path

1. Performance tuning for Delta Lake queries
2. Monitor Tiered Tables status and storage savings
3. Advanced Iceberg catalog management (section link — to be provided)
4. Architectural patterns for real-time vs. batch analytics (section link — to be provided)
5. Analytics use cases and industry solutions
6. Analytics Accelerator for your role
7. Security best practices for analytics environments (section link — to be provided)

Next steps

Consider official training and certification:

• EDB Training portal