12.2. Verifying Available Network, Storage, and Computational Resources #
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 executing stored procedures.
Create a diagram that illustrates data flows between storages.
Ensure that the network and storages provide sufficient throughput to execute 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 execute regular stored procedures 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.