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 <https://enterprisedb.com/docs/edb-postgres-ai/analytics/learn/explained/analytics-concepts>`_  

Suggested learning path
-----------------------

1. :ref:`Performance tuning for Delta Lake queries <Queries>` 

2. `Monitor Tiered Tables status and storage savings <https://enterprisedb.com/docs/edb-postgres-ai/hybrid-manager/analytics/learn/how-to/monitor-tiered-tables>`_ 

3. :ref:`Advanced Iceberg catalog management <../explained/>`  *(section link — to be provided)*

4. :ref:`Architectural patterns for real-time vs. batch analytics <../explained/>`  *(section link — to be provided)*

5. `Analytics use cases and industry solutions <https://enterprisedb.com/docs/edb-postgres-ai/hybrid-manager/analytics/learn/use-cases.mdx>`_ 

6. :ref:`Analytics Accelerator for your role <a persona-based guide>` 

7. :ref:`Security best practices for analytics environments <../explained/>`  *(section link — to be provided)*

Next steps
----------

Consider official training and certification:

- `EDB Training portal <https://enterprisedb.com/docs/edb-postgres-ai/analytics/learn/paths#edb-training-and-certification>`_