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