public inbox for [email protected]  

help / color / mirror / Atom feed

From: Pierre Barre <[email protected]>
To: [email protected]
Subject: VACUUM FULL, power failure results in unrecoverable space
Date: Tue, 03 Dec 2024 01:02:13 +0100
Message-ID: <[email protected]> (raw)

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: VACUUM FULL, power failure results in unrecoverable space
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox