pgpro_axe provides a cache for Parquet files from S3 storages to reduce storage read I/O requirements. The cache size is restricted by the pgpro_axe memory limit, specified by the duckdb.max_memory configuration parameter. Parquet files are cached until this limit is reached.

By default, the cache is enabled. To disable it, set the duckdb.enable_external_file_cache configuration parameter to false on the Postgres Pro AXE server.

You can retrieve information about cached Parquet files. For more information, refer to Section 25.6.