On 6/17/23 00:32, Quan Zongliang wrote: > ... > > It's not just a small table. If a column's value is nearly unique. It > also causes the same problem because we exclude values that occur only > once. samplerows <= num_mcv just solves one scenario. > Perhaps we should discard this (dups cnt > 1) restriction? >
But for larger tables we'll be unable to keep all the values in the MCV. So I think this only can change things for tiny tables. regards -- Tomas Vondra EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
