On Thu, May 8, 2025 at 12:10 PM Sami Imseih <samims...@gmail.com> wrote: > I think it's better to simply disable the truncate work and perform it > at a later time > than introduce some new limit to how many times the truncation can be > suspended. > In the type of workload you are referring to, it is likely that the > truncation will > end up not completing, so why even try at all? >
Yeah, I pretty much had the same thought; if you bail out after some kind of cap, there will be workloads that will never complete the truncate heap phase, in which case you should probably be using truncate off. But the one thing I was a bit sympathetic on was how to actually determine you are in this situation, or how bad the situation was, in order to know that setting truncate off would help? To that end, I wonder if it'd be worth adding the counter and printing that information (and maybe elapsed time in this phase?) in vacuum verbose output? Robert Treat https://xzilla.net
