public inbox for [email protected]  

help / color / mirror / Atom feed

From: Thomas Simpson <[email protected]>
To: [email protected]
Subject: filesystem full during vacuum - space recovery issues
Date: Mon, 15 Jul 2024 14:47:28 -0400
Message-ID: <[email protected]> (raw)

Hi

I have a large database (multi TB) which had a vacuum full running but 
the database ran out of space during the rebuild of one of the large 
data tables.

Cleaning down the WAL files got the database restarted (an archiving 
problem led to the initial disk full).

However, the disk space is still at 99% as it appears the large table 
rebuild files are still hanging around using space and have not been 
deleted.

My problem now is how do I get this space back to return my free space 
back to where it should be?

I tried some scripts to map the data files to relations but this didn't 
work as removing some files led to startup failure despite them 
appearing to be unrelated to anything in the database - I had to put 
them back and then startup worked.

Any suggestions here?

Thanks

Tom

view thread (2+ messages)

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: filesystem full during vacuum - space recovery issues
  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