search

h2oai / db-benchmark

reproducible benchmark of database-like ops
https://h2oai.github.io/db-benchmark
Mozilla Public License 2.0
321 stars 85 forks source link

clickhouse join fails for 1e9 data size #169

Open jangorecki opened 3 years ago

jangorecki commented 3 years ago

After completing first question and first run, CH is crashing at second run of first question with the following error:

Received exception from server (version 20.9.3):
Code: 241. DB::Exception: Received from localhost:9000. DB::Exception: Memory limit (total) exceeded: would use 113.21 GiB (attempt to allocate chunk of 6783276 bytes), maximum: 113.20 GiB: While executing SinkToOutputStream.

Would be nice to know if there is a way we can tune it somehow.