DuckDb Benchmark config

duckdb_benchmark_config.sql

-- enabling profile mode
PRAGMA enable_profile;
SET enable_profiling = 'query_tree_optimizer';
SET profiling_mode = 'DETAILED';
SET enable_progress_bar_print=true;
SET enable_progress_bar=true;
SET explain_output='ALL';
SET preserve_insertion_order = false; -- allow to bigger than memory query.
set temp_directory='/tmp/duckdb-temp';
SET parquet_metadata_cache=false;

-- low config
SET max_memory = '500 MiB';
SET memory_limit = '500 MiB';
SET threads=1;

-- high config
SET max_memory = '4096 MiB';
SET memory_limit = '4096 MiB';
SET threads=8;