Re: Overhauling "Routine Vacuuming" docs, particularly its handling of freezing

2023-05-12 Thread Ryan Booz
y... * advancing the transaction ID space on generally static tables... * ensure there are always free transaction IDs available for normal operation... " Maybe totally worthless and too much, but something like that might set a reader up for just a bit more context. Then you could take most of what comes before "2.5.2.2.1 Aggressive Vacuum" as a subsection (would require a renumber below) with something like "2.5.2.2.1 Normal Freezing Activity" 8) Note "In PostgreSQL versions before 16..." Showing my naivety, somehow this isn't connecting with me totally. If it's important to call out, then maybe we need a connecting sentence. Based on the content above, I think you're pointing to "It's also why VACUUM will freeze all eligible tuples from a heap page once the decision to freeze at least one tuple is taken:" If that's it, it's just not clear to me what's totally changed. Sorry, more learning. :-) --- Hope something in there is helpful. Ryan Booz > > -- > Peter Geoghegan

Re: Overhauling "Routine Vacuuming" docs, particularly its handling of freezing

2023-05-12 Thread Ryan Booz
And, of course, I forgot that I switch to text-mode after writing most of this, so the carriage returns were unnecessary. (facepalm... sigh) -- Ryan On Fri, May 12, 2023 at 1:36 PM Ryan Booz wrote: > > Thanks for the continued work, Peter. I hate to be the guy that starts this > w