When deploying Postgres Pro AXE, distribute the OLAP workload across servers so that the resulting topology meets performance requirements.
Recommendations for building the topology:
Identify the main OLAP processes and applications, and define time limits for performing ETL operations.
Create a diagram that illustrates data flows between storages.
Ensure that the network and storages provide sufficient throughput to perform operations, with a recommended 30% margin.
Select servers to use for processing most of the OLAP workload and ensure that they have sufficient computational resources to perform regular ETL operations within the required time limits, with a recommended 30% margin.
Ensure that there are no bottlenecks. If there are, consider adding computational resources or modifying the topology.