Part III. Deployment
Prev UpPostgres Pro AXE 1.1.0 DocumentationHome Next

Part III. Deployment

The Postgres Pro AXE deployment process includes the following steps:

  1. Identify the OLAP data processing scenario and the deployment scenario.

  2. Ensure that your servers meet hardware and software requirements.

  3. Allocate sufficient computational resources for executing analytical queries.

  4. Identify user groups and usage scenarios.

  5. Organize stored procedures.

  6. Plan the scalability of compute resources.

  7. Provide high availability.

  8. Install Postgres Pro AXE.

Table of Contents

11. OLAP Data Processing Scenarios
12. Deployment Scenarios
12.1. Impact on OLTP Workload from Analytical Queries
12.2. Verifying Available Network, Storage, and Computational Resources
13. Hardware and Software Requirements
14. Capacity Planning
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
15. Identifying User Groups and Usage Scenarios
16. Organizing Stored Procedures
17. Planning the Scalability of Compute Resources
18. Providing High Availability
19. Installing Postgres Pro AXE
20. Retrieving the pgpro_metastore Build Number (metastore.pgpro_build)
21. Updating and Deleting Postgres Pro AXE
21.1. Updating Postgres Pro AXE
21.2. Deleting Postgres Pro AXE
Prev Up Next
Chapter 10. Typical Commands for Working with the OLAP Data Home Chapter 11. OLAP Data Processing Scenarios