Re: Unused files in the database directory after crashed VACUUM FULL - Mailing list pgsql-general

From Andrew Gierth
Subject Re: Unused files in the database directory after crashed VACUUM FULL
Date
Msg-id 87ftsvr6e7.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Re: Unused files in the database directory after crashed VACUUM FULL  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:

 > Hannes Erven <hannes@erven.at> writes:
 >> I've just had a "VACUUM FULL <table>" crash due to 100% disk usage.
 >> Clearly my fault, I was expecting the new table to be small enough.

 Tom> What do you mean by "crash" exactly? A normal transactional
 Tom> failure should've cleaned up orphaned files. I suppose if the
 Tom> kernel decided to kill -9 the vacuum process, that wouldn't happen
 Tom> --- but that's not the usual response to out-of-disk-space.

The failure mode of this kind we see reported most often is getting a
PANIC failure from inability to extend the WAL.

-- 
Andrew (irc:RhodiumToad)


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Unused files in the database directory after crashed VACUUM FULL
Next
From: Martín Fernández
Date:
Subject: Promote replica before being able to accept connections