B.5. Storage #
The parameters below control file storages.
duckdb.temporary_directory(text) #The directory for temporary files that pgpro_axe creates when the available RAM is insufficient for executing analytical queries. For more information, refer to Section 7.2.
You can limit the size of this directory using the
duckdb.max_temp_directory_sizeconfiguration parameter.Default value:
DataDir/pg_duckdb/temp.Access: Superuser only.
-
duckdb.max_temp_directory_size(text) # The maximum size of the temporary directory specified by the
duckdb.temporary_directoryconfiguration parameter. Limiting the directory size prevents analytical queries from consuming all available disk space.Possible values:
"10GB""500MB""2TB"
Default value:
""(empty value) — the directory size is not limited.Access: Superuser only.
duckdb.extension_directory(text) #The directory where pgpro_axe stores DuckDB extensions. This is useful for storing extensions on a separate disk or sharing them across multiple Postgres Pro AXE instances.
Default value:
DataDir/pg_duckdb/extensions.Access: Superuser only.
duckdb.enable_external_file_cache(boolean) #Specifies whether pgpro_axe caches Parquet files from S3 storages in RAM to reduce storage read I/O. For more information, refer to Section 14.3.
Default value:
true.Access: Superuser only.
duckdb.default_collation(text) #The default collation that pgpro_axe uses for string operations and sorting. This is useful for configuring locale-specific string comparison behavior.
Possible values:
"en_us""de_de""C"
Default value:
""(empty value) — no collation is specified.Access: Superuser only.