23.4. Storage #
duckdb.temporary_directory#Specifies the directory where DuckDB writes temporary files. By default, DuckDB uses a directory under the Postgres Pro directory (
DataDir/pg_duckdb/temp). This parameter can be useful for pointing to faster storage (e.g., an SSD) or managing disk space more effectively.Default value:
"DataDir/pg_duckdb/temp".Access: Superuser-only.
duckdb.max_temp_directory_size / duckdb.max_temporary_directory_size#The maximum amount of data that can be stored in the DuckDB temporary directory. This parameter allows preventing runaway queries from consuming all available disk space.
Example 23.5.
"10GB""500MB""2TB"
Default value:
""— no limit is enforced.Access: Superuser-only.
duckdb.extension_directory#Specifies the directory where DuckDB stores its extensions. By default, extensions are stored under the Postgres Pro directory (
DataDir/pg_duckdb/extensions). This is useful for managing the extension storage or sharing extensions across multiple Postgres Pro instances.Default value:
"DataDir/pg_duckdb/extensions".Access: Superuser-only.