Chapter 7. Capacity Planning

Table of Contents

7.1. Total Amount of OLAP Data in the Storage
7.2. Amount of Data Processed by a Standard Analytical Query
7.3. Required Analytical Query Execution Time
7.4. Number of Analytical Queries Executed per Unit of Time
7.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.