On Tue, Dec 17, 2019 at 03:30:33PM -0800, Peter Geoghegan wrote: > With many real world unique indexes, the true reason behind most or > all B-Tree page splits is "version churn". I view these page splits as > a permanent solution to a temporary problem -- we *permanently* > degrade the index structure in order to deal with a *temporary* burst > in versions that need to be stored. That's really bad.
Yes, I was thinking why do we need to optimize duplicates in a unique index but then remembered is a version problem. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +
