pgpro_axe executes SQL commands within a single server and is limited by the server capacity. Typically, the limit of data that pgpro_axe can process in a single SQL command on an average server (256 CPU, 2 TB RAM) does not exceed 100 TB.

To process a larger data scope, split the initial data into smaller parts. Process each part in a separate analytical query and save the result in a temporary table. After processing all parts, combine the results in a final analytical query.

For the massively parallel mode with many servers involved, it is required either to balance SQL commands at the application level or to make use of proxima.

The pgpro_axe SQL syntax is compatible with but does not fully match the PostgreSQL syntax. Certain analytical queries operating within Postgres Pro must be modified to be executable in pgpro_axe .