Re: Poor performance using reftable with many refs

From: Christian Couder <christian.couder@gmail.com>
Date: Feb 13, 2025, 09:27 UTC
Message-ID: <CAP8UFD3E8_mTwneUgNkC_hZbkaeznAT-dG9njT5wjnm-=iMmcw@mail.gmail.com>
In-Reply-To: <Z62booOOXODOl_sZ@pks.im>

On Thu, Feb 13, 2025 at 8:13 AM Patrick Steinhardt <ps@pks.im> wrote:

Show 6 quoted lines

> We end up with two tables: the first one has been created when cloning
> the repository and contains all references. The second one has been
> created when deleting all references, so it only contains ref deletions.
> Because deletions don't have to carry an object ID, the resulting table
> is also much smaller. This has the effect that auto-compaction does not
> kick in, because we see that the geometric sequence is still intact.

Not that I think we should work on this right now, but theoretically, could we "just" count the number of entries in each file and base the geometric sequence on the number of entries in each file instead of file size?