Chapter 14. Capacity Planning

Table of Contents

14.1. Total Amount of OLAP Data in the Storage
14.2. Amount of Data Processed by a Standard Analytical Query
14.3. Required Analytical Query Execution Time
14.4. Number of Analytical Queries Executed per Unit of Time
14.5. Considerations and Limitations

When deploying Postgres Pro AXE, sufficient computational resources must be allocated for executing analytical queries. The amount of required resources is determined by the following storage characteristics:

This section provides guidelines for estimating the computational resources required for different OLAP workloads.

After deploying Postgres Pro AXE, monitor the available computational resources and be prepared to allocate additional resources outside the scope of this estimation if required.