Guides
The `preserve_insertion_order` Option
When importing or exporting data sets (from/to the Parquet or CSV formats), which are much larger than the available memory, an out of memory error may occur:  
```console
Error: Out of Memory Error: failed to allocate data of size ... (.../... used)
```  
In these cases, consider setting the [`preserve_insertion_order` configuration option](#docs:configuration:overview) to `false`:  
```sql
SET preserve_insertion_order = false;
```  
This allows the systems to re-order any results that do not contain `ORDER BY` clauses, potentially reducing memory usage.