elastic_cluster good value and clarification.
Hi, I have a 5 node cluster, and wonder what should be a good value for scaling_factor. and is_local_segment_enabled. The defaults (or at least my current values) are 4 and false, respectively. If I understand well, the scaling_factor does not matter too much if the number of nodes does not change often. Is that right? Regarding the is_local_segment_enabled, what impact/consequences would this one have? We have a (apparently) very busy instance of Vertica, even if we are not too sure yet where the apparent slowness come from. One of our table in particular contains about 8 billions rows, is partitioned on one column, with every day a few tens of millions added and removed. My guess is that local_segment enabled, the rows would be more evenly spread over the cluster, thus leading to better performance? Thanks,