>>>>> "Tom" == Tom Lane <tgl@xxxxxxxxxxxxx> writes: > Hannes Erven <hannes@xxxxxxxx> 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)
