I'm using a terms aggregation in Elasticsearch and have a question about the size parameter.
If I set size: 1000 in the aggregation, but the actual number of buckets returned is always much lower—say around 150—does this have any impact on memory usage or performance?
Is it more efficient to set size closer to the expected number of buckets, or is there no real penalty for setting it higher than necessary?
Looking to understand the trade-offs here.