Services
  • 24×7×365 Technical Support
  • Migration to PostgreSQL
  • High Availability Deployment
  • Database Audit
  • Remote DBA for PostgreSQL
Products
  • Postgres Pro Enterprise
  • Postgres Pro Standard
  • Postgres Pro Shardman
  • Postgres Pro Enterprise Manager
  • Postgres Pro ProGate
  • Cloud Solutions
  • Postgres Extensions
Cases
Courses
Resources
  • Blog
  • Documentation
  • Webinars
  • Videos
  • Presentations
Community
  • Events
  • Books
  • Demo Database
  • Mailing List Archives
About
  • Leadership team
  • Partners
  • Customers
  • In the News
  • Press Releases
  • Press Info

Facebook
Postgres Pro
  • Services
    24×7×365 Technical Support Migration to PostgreSQL High Availability Deployment Database Audit Remote DBA for PostgreSQL
  • Products
    Postgres Pro Enterprise Postgres Pro Standard Postgres Pro Shardman Postgres Pro Enterprise Manager Postgres Pro ProGate Cloud Solutions Postgres Extensions
  • Cases
  • Courses
  • Resources
    Blog Documentation Webinars Videos Presentations
  • Community
    Events Books Demo Database Mailing List Archives
  • About
    Leadership team Partners Customers In the News Press Releases Press Info
Facebook
Request a Demo
Part II. Deployment
Prev UpPostgres Pro AXE 1.1.1 DocumentationHome Next

Part II. Deployment

The Postgres Pro AXE deployment process includes the following steps:

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

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

  3. Allocate sufficient compute 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

5. Data Processing Scenarios
6. Deployment Scenarios
6.1. Impact on OLTP Workload from Analytical Queries
6.2. Verifying Available Network, Storage, and Compute Resources
7. Hardware and Software Requirements
8. Capacity Planning
8.1. Calculating Storage Capacity
8.2. Estimating Required Compute Resources
8.3. Calculating Server Capacity
8.4. Managing RAM Consumption
9. Identifying User Groups and Usage Scenarios
10. Organizing Stored Procedures
11. Planning the Scalability of Compute Resources
12. Providing High Availability
13. Installing Postgres Pro AXE
14. Installing Additional Extensions (duckdb.install_extension)
14.1. Installing the Iceberg Extension
14.2. Installing the Delta Extension
15. Retrieving the pgpro_metastore Build Number (metastore.pgpro_build)
16. Restarting pgpro_axe (duckdb.recycle_ddb)
17. Updating and Deleting Postgres Pro AXE
17.1. Updating Postgres Pro AXE
17.2. Deleting Postgres Pro AXE

Prev Up Next
Chapter 4. Quick Start Home Chapter 5. Data Processing Scenarios
epub pdf
Есть вопросы? Напишите нам!

Соглашаюсь с условиями обработки персональных данных



✖
×
Postgres Pro AXE 1
Go to Postgres Pro AXE 1
Services
  • 24×7×365 Technical Support
  • Migration to PostgreSQL
  • High Availability Deployment
  • Database Audit
  • Remote DBA for PostgreSQL
Products
  • Postgres Pro Enterprise
  • Postgres Pro Standard
  • Postgres Pro Shardman
  • Postgres Pro Enterprise Manager
  • Postgres Pro ProGate
  • Cloud Solutions
  • Postgres Extensions
Cases
Courses
Resources
  • Blog
  • Documentation
  • Webinars
  • Videos
  • Presentations
Community
  • Events
  • Books
  • Demo Database
  • Mailing List Archives
About
  • Leadership team
  • Partners
  • Customers
  • In the News
  • Press Releases
  • Press Info
Products
  • Postgres Pro Enterprise
  • Postgres Pro Standard
  • Postgres Pro Shardman
  • Postgres Pro Enterprise Manager
  • Postgres Pro ProGate
  • Cloud Solutions
  • Postgres Extensions
Resources
  • Blog
  • Documentation
  • Webinars
  • Videos
  • Presentations
Services
  • 24×7×365 Technical Support
  • Migration to Postgres
  • High Availability Deployment
  • Database Audit
  • Remote DBA for PostgreSQL
Community
  • Events
  • Training Courses
  • Intro Book
  • Demo Database
  • Mailing List Archives
About
  • Leadership team
  • Partners
  • Cases
  • In the News
  • Press Releases
  • Press Info
Contacts
  • Neptune House, Marina Bay, office 207, Gibraltar, GX11 1AA
  • info@postgrespro.com
  • Facebook
Get in touch!



© Postgres Professional Europe Limited, 2015 — 2026
EULA EULA for Cloud Environments Privacy Policy GDPR Compliance Commitment
© Postgres Professional Europe Limited, 2015 — 2026
EULA
EULA for Cloud Environments
Privacy Policy
GDPR Compliance Commitment
By continuing to browse this website, you agree to the use of cookies. Go to Privacy Policy.