3 ms·
> The two main knobs are my experience is that those are not enough, multiple algorithms will just fail saying you hit max memory limit. There are many other
by riku_iki 3y ago
> The two main knobs are
my experience is that those are not enough, multiple algorithms will just fail saying you hit max memory limit. There are many other knobs, for example: when to start external aggregation or sorting. For some cases I couldn't figure out setup and query just hits OOM without any ideas how to fix it.
- FridgeSeal 3y agoHow is your table setup? It’s plausible the on-disk/index layout is not amenable to the kinds of queries you’re trying to do. What kind of queries are you trying to do? Also, what kind of machine are you running on?
- riku_iki 3y agoTrivial example would be to run select count(distinct) from large table with high cardinality values: https://github.com/ClickHouse/ClickHouse/issues/47520 https://github.com/ClickHouse/ClickHouse/issues/47520