Chapter 2. Deployment
Prev	Up	Postgres Pro AXE 1.0.0 Documentation	Home	Next

Chapter 2. Deployment

Table of Contents

2.1. OLAP Data Processing Scenarios

2.2. Deployment Scenarios

2.2.1. Impact on OLTP Workload from Analytical Queries
2.2.2. Verifying Available Network, Storage, and Computational Resources

2.3. Hardware and Software Requirements

2.4. Capacity Planning

2.4.1. Total Amount of OLAP Data in the Storage
2.4.2. Amount of Data Processed by a Standard Analytical Query
2.4.3. Required Analytical Query Execution Time
2.4.4. Number of Analytical Queries Executed per Unit of Time
2.4.5. Considerations and Limitations

2.5. Identifying User Groups and Usage Scenarios

2.6. Organizing ETL operations

2.7. Planning the Scalability of Compute Resources

2.8. Providing High Availability

2.9. Installing Postgres Pro AXE

2.10. Updating and Deleting Postgres Pro AXE

2.10.1. Updating Postgres Pro AXE
2.10.2. Deleting Postgres Pro AXE

The Postgres Pro AXE deployment process includes the following steps:

Identify the OLAP data processing scenario and the deployment scenario.
Ensure that your servers meet hardware and software requirements.
Allocate sufficient computational resources for executing analytical queries.
Identify user groups and usage scenarios.
Organize ETL operations.
Plan the scalability of compute resources.
Provide high availability.
Install Postgres Pro AXE.

Prev	Up	Next
Chapter 1. Overview	Home	2.1. OLAP Data Processing Scenarios

epub pdf