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 reclaim this space, but during execution, the server experienced a power failure. After server recovery: 1. The database came back online successfully 2. The space used by the in-progress table reconstruction was not freed 3. The newly wasted space (bloat + partial VACUUM FULL) is not shown using the above query, only the initial bloat. Is there a way to reclaim this space without resorting to a full pg_dump and pg_restore cycle? Thanks. Best, Pierre
