Skip to content

Conversation

Y--
Copy link
Collaborator

@Y-- Y-- commented Apr 2, 2025

Add 3 new DuckDB options to the GUC:

  • duckdb.extension_directory - Set the directory to store extensions in, by default in <DataDir>/pg_duckdb/extensions
  • duckdb.temporary_directory - Set the directory to which to write temp files, by default in <DataDir>/pg_duckdb/temp
  • duckdb.max_temp_directory_size - The maximum amount of data stored inside the 'temp_directory' (when set) (e.g., 1GB)

(Cf. DuckDB's documentation https://duckdb.org/docs/stable/configuration/overview)

Solves #666
Fixes #684

@Y-- Y-- requested a review from JelteF April 2, 2025 09:14
@Y-- Y-- linked an issue Apr 2, 2025 that may be closed by this pull request
@JelteF JelteF merged commit 9279a53 into yl/secrets-ddb-fdw Apr 15, 2025
6 checks passed
@JelteF JelteF deleted the yl/temp-dir-path branch April 15, 2025 08:51
@JelteF JelteF restored the yl/temp-dir-path branch April 15, 2025 08:52
@JelteF JelteF deleted the yl/temp-dir-path branch April 15, 2025 08:52
@Y-- Y-- restored the yl/temp-dir-path branch April 15, 2025 11:29
Y-- added a commit that referenced this pull request Apr 15, 2025
Y-- added a commit that referenced this pull request Apr 15, 2025
Add 3 new DuckDB options to the GUC:
* `duckdb.extension_directory` - Set the directory to store extensions
in, by default in `<DataDir>/pg_duckdb/extensions`
* `duckdb.temporary_directory` - Set the directory to which to write
temp files, by default in `<DataDir>/pg_duckdb/temp`
* `duckdb.max_temp_directory_size` - The maximum amount of data stored
inside the 'temp_directory' (when set) (e.g., 1GB)

(Cf. DuckDB's documentation
https://duckdb.org/docs/stable/configuration/overview)

Solves #666
Fixes #684
Y-- added a commit that referenced this pull request Apr 15, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

Temporary files should go in the postgres temp directory by default
2 participants