20x performance difference between two VMs running the same version of Elastic opendistro

i’ve just spent way too much time trying to figure out why the same query run on one VM with elastic 0.1s while on another – 2s. both VMs were running on the same physical server, had the same amount of cores allocated. i’ve finally found it – there was a tiny difference in amount …

Continue reading ‘20x performance difference between two VMs running the same version of Elastic opendistro’ »

ClickHouse – dictionary with string keys

i wanted to create a clickhouse dictionary that used String as a key, not an int. docs mention here: “A composite key can consist of a single element. This makes it possible to use a string as the key, for instance”. I’ve been trying this and failed few times. creation worked but i could not …

Continue reading ‘ClickHouse – dictionary with string keys’ »