Have you considered splitting data into hot (last 3 months) and cold to reduce load instead of Elasticsearch?