On Fri, Jun 18, 2021 at 3:43 PM Tomas Vondra <tomas.von...@enterprisedb.com> wrote:
> Sorry, I'm not sure what you mean by "we set the number of MCVs to the > number of histograms" :-( > > When you say "MCV limit" you mean that we limit the number of items to > statistics target, right? I agree plan time is one concern - but it's > also about analyze, as we need larger sample to build a larger MCV or > histogram (as the paper you referenced shows). Ah, I didn't realize the theoretical limit applied to the MCVs too, but that makes sense since they're basically singleton histogram buckets. -- John Naylor EDB: http://www.enterprisedb.com
