pgpro_axe executes SQL queries within a single server and is limited by the server capacity. Typically, limit of data that the pgpro_axe can process in a single SQL query 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, unite the results in a final analytical query.

For the massively parallel mode with many servers involved, it is required either to balance SQL queries 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 queries operating within Postgres Pro must be modified to be executable in pgpro_axe.