On Wed, Oct 22, 2025 at 08:44:27AM +0300, Alvaro Herrera wrote:
> FWIW I don't necessarily agree with what Sami is proposing, but (if I
> understand the situation correctly) I think throwing away the whole
> contents of stats when a module is removed is the opposite of
> availability, as it will lead to autovacuum lacking data and thus bloat
> problems. This is of course always problematic after a crash (unless
> somebody has fixed this already?) but at least it is supposed to be a
> known issue.
A first part here is something that Bertrand Drouvot has been working
on: being able to rebuild the table stats during WAL replay requires
us to move the stats to be relfilenode-based, so as the startup could
know where to recreate some of the numbers lost during crash recovery
from WAL, giving autovacuum a safety net.
> With these custom stat kind thingies, nobody knows that this problem
> exists.
Noted.
--
Michael