I will give a try with 500 mb and higher and check it out

So increasing segment size will reduce number of threads needed, and help increase throughput, as threads freed to fields more queries . But may increase latency a bit due to reduced parallelism (depends on your query). To improve latency as well, one option is to enable real-time aggregation of metrics - for events with same dimensions, metrics are aggregated at write time, instead of creating new row).