Settings

Settings

Read, write, or list runtime settings from Scheme:

<syntaxhighlight lang="scheme">(settings "ShardSize") (settings "ExplainWidth" 80) (settings)</syntaxhighlight> Settings are stored with the database catalog. Validate production changes in a staging workload; memory, planner, and durability-related values affect behavior.

Setting	Default	Purpose
Backtrace	false	Retain more Scheme source/backtrace information.
Trace, TracePrint	false	Runtime trace collection and printing.
PartitionMaxDimensions	10	Maximum adaptive partition dimensions.
DefaultEngine	safe	One of safe, logged, sloppy, memory, cache.
ShardSize	60000	Target rows used by shard/repartition decisions.
AnalyzeMinItems	50	Minimum work before recording scan statistics.
IndexThreshold	5	Minimum shard rows for a new adaptive index.
MaxRamPercent	50	Overall MemCP RAM budget when byte override is zero.
MaxRamBytes	0	Exact overall budget; zero uses percentage.
MaxPersistPercent	30	Budget for reloadable persisted data.
MaxPersistBytes	0	Exact persisted-data budget.
MetricsTracing	false	Periodically write performance metrics.
MetricsTracingInterval	60	Metrics interval in seconds when zero/defaulted.
ShutdownDrainSeconds	10	Wait for in-flight requests during shutdown.
LogJIT	false	Log native JIT compilation details.
ScanDebugging	false	Log scan boundaries, index selection, and scan details.
ExplainWidth	20	Pretty-print width for EXPLAIN expressions.
JoinReorderDPBudget	256	Connected subsets retained by exact join search.
ErrorQueryLog	false	Store failed queries in system_statistic.errors.
MaxErrorQueryLog	0	Error-log row limit; zero is unlimited.
PrintLog	false	Store Scheme print/time output.
MaxPrintLog	0	Print-log row limit; zero is unlimited.

Use Memory Management and Eviction, Query Planner and Physical Lowering, and Dashboard and Operations for operational context.