On Tue, 2023-09-19 at 14:50 -0400, Robert Haas wrote: > But I know people will try to use it for instant compaction too, and > there it's worth remembering why we removed old-style VACUUM FULL. The > main problem is that it was mind-bogglingly slow. The other really bad > problem is that it caused massive index bloat. I think any system > that's based on moving around my tuples right now to make my table > smaller right now is likely to have similar issues.
I had the same feeling that this is sort of bringing back old-style VACUUM (FULL). But I don't think that index bloat is a show stopper these days, when we have REINDEX CONCURRENTLY, so I am not worried. Yours, Laurenz Albe
