On Tue, May 11, 2021 at 1:41 PM Bruce Momjian <br...@momjian.us> wrote: > > "Allow VACUUM to eagerly place newly deleted B-Tree pages in the Free > > Space Map. Previously VACUUM could only place preexisting deleted > > pages in the Free Space Map for recycling." > > So, previously it could only place pages that were deleted from the > previous vacuum on the free list?
Yes, exactly -- that's how it worked, even though in general there was no way to predict when the next VACUUM would be. Now VACUUM will usually manage to do everything in the same VACUUM operation, starting from deleting the index tuples that make the page empty, then deleting the page, and finally putting the page in the FSM. Makes a big difference when the workload has lots of page deletions, say due to range deletions. -- Peter Geoghegan
