The problem I have currently with aws is there's no way to grow local storage without horizontally expanding. EBS is just not able to handle queries with the amount of data you and I have. Plus, EBS is pretty costly compared to local storage. If you have to use aws, make sure to use instances with nvme storage @61meg ram (which doesn't allow for a lot of data node storage). This lack of local storage has pushed me to configure my own on-premise servers to get as much performance as possible, and to have the ability to add more memory/storage to a node rather than increase number of nodes, this works as long as processing power is not completely consumed. Still working on the new cluster.