Certain analytical queries require a large amount of RAM, particularly:

If pgpro_axe lacks RAM for executing an analytical query, the data is automatically placed in temporary files, which significantly increases query execution time. Temporary files are located in the directory specified by the duckdb.temporary_directory configuration parameter.

Monitor the amount of temporary files created by pgpro_axe every 24 hours and avoid peak values.

To maximize the number of analytical queries processed per second, ensure that most analytical queries are processed in RAM. However, temporary files can be used for resource-intensive analytical queries with long execution time (hours).