Re: PoC: Compute a histogram of prune_xid to support autovacuum improvements

2025-06-04 Thread Renan Alves Fonseca
Renan Alves Fonseca writes: > histogram. In my tests, not always, a small annoying difference shows > up. Actually, it is really annoying, I'm struggling with it and I hope > someone helps me to find the missing bits. Finally, I've found out that this error has been triggered by my test script.

PoC: Compute a histogram of prune_xid to support autovacuum improvements

2025-06-03 Thread Renan Alves Fonseca
Hi all, in the scope of improving the autovacuum algorithm, this patch proposes to maintain a histogram of *smallest prunable xid per page* for each relation. It allows to estimate the number of pages that would be pruned by vacuum for a given cutoff. The *smallest prunable xid per page* is prune