settings.sql

On this page

Settings: DuckDB runtime configuration

Phase: Pre-catalog | Order: 1 | Required: No

Controls how DuckDB executes queries: memory usage, parallelism, and disk spill behavior.

SET memory_limit = '8GB';
SET threads = 4;
SET temp_directory = '/tmp/duckdb';
SET TimeZone = 'Europe/Stockholm';

Settings

Setting	Default	Description
`memory_limit`	80% of system RAM	Maximum memory for the runtime
`threads`	All available cores	Number of parallel execution threads
`temp_directory`	`.tmp`	Disk spill location when memory is exceeded
`TimeZone`	System timezone	Timestamp interpretation