Configuration
Examples
Set the memory limit of the system to 10 GB.  
```sql
SET memory_limit = '10GB';
```  
Configure the system to use 1 thread.  
```sql
SET threads TO 1;
```  
Enable printing of a progress bar during long-running queries.  
```sql
SET enable_progress_bar = true;
```  
Set the default null order to `NULLS LAST`.  
```sql
SET default_null_order = 'nulls_last';
```  
Return the current value of a specific setting.  
```sql
SELECT current_setting('threads') AS threads;
```  
| threads |
|--------:|
| 10      |  
Query a specific setting.  
```sql
SELECT *
FROM duckdb_settings()
WHERE name = 'threads';
```  
|  name   | value |                   description                   | input_type | scope  |
|---------|-------|-------------------------------------------------|------------|--------|
| threads | 1     | The number of total threads used by the system. | BIGINT     | GLOBAL |  
Show a list of all available settings.  
```sql
SELECT *
FROM duckdb_settings();
```  
Reset the memory limit of the system back to the default.  
```sql
RESET memory_limit;
```