Combatting Out Of Memory Errors With ClickHouse

max_bytes_before_external_group_by

Don’t set it too low

max_threads

max_insert_threads

Ordering DAta

optimize_on_insert = 0