Re: VACUUM FULL, power failure results in unrecoverable space

Hi, Le mar. 3 déc. 2024, 01:02, Pierre Barre a écrit : > Hello, > > I encountered an issue while attempting to reclaim space from a heavily > bloated table: > > Initial analysis using > https://github.com/ioguix/pgsql-bloat-estimation/blob/master/table/table_bloat.sql > indicated > approximate

VACUUM FULL, power failure results in unrecoverable space

Hello, I encountered an issue while attempting to reclaim space from a heavily bloated table: Initial analysis using https://github.com/ioguix/pgsql-bloat-estimation/blob/master/table/table_bloat.sql indicated approximately 600GB of bloat in the table. I initiated a VACUUM FULL operation to r