Alvaro Herrera <alvhe...@alvh.no-ip.org> writes: > Now about the former. If we do think that recompressing causes an > unacceptable 10% slowdown for every single VACUUM FULLs, then yeah we > should discuss changing that behavior -- maybe remove promises of > recompression and wait for pg15 to add "VACUUM (RECOMPRESS)" or > similar. > If it's a 10% slowdown of the only best times (variability unspecified) > and only in corner cases (unlogged tables with no indexes that fit in > shared buffers), then I don't think we should bother.
BTW, perhaps I should clarify my goal here: it's to cut off expending further effort on this feature during v14. If we can decide that the existing performance situation is acceptable, I'm content with that decision. But if we're to start designing new user-visible behavior to satisfy performance objections, then I'd prefer to remove this VACUUM behavior altogether for now. regards, tom lane