The ES7.x doc for composite aggregation warns that : “The composite aggregation is expensive. Load test your application before deploying a composite aggregation in production.”
Some context: My team and I are hoping to replace some of our terms aggregation queries with composite aggregation due to high cardinality. We plan to make the shift to composite aggregation and paginate through the results.
Discussion: I'm looking for some insights regarding its impact on overall performance, since I have limited experience with using composite aggregation.