Re: Unused files in the database directory after crashed VACUUM FULL

>>>>> "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)