From: | Antti Salmela <asalmela(at)iki(dot)fi> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: Failed CLUSTER seems to leave files behind |
Date: | 2005-11-03 17:29:38 |
Message-ID: | 20051103172938.GA32225@asalmela.iki.fi |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Thu, Nov 03, 2005 at 10:03:16AM -0500, Tom Lane wrote:
> Antti Salmela <asalmela(at)iki(dot)fi> writes:
> > Failed CLUSTER due to insufficient disk space seems to leave temporary files
> > behind at least on 7.4.7.
>
> What was the "failure" exactly? If you ran out of disk space for the
> data files, I'd have expected it to reclaim the temp files. On the
> other hand, running out of disk space for WAL would lead to a
> database-wide PANIC, and there's no mechanism for getting rid of
> unreferenced files after a PANIC. (IIRC this is intentional ---
> deleting files that we think aren't used seems too risky.)
PANIC'ed.
> This is one of several reasons for keeping WAL and data on separate
> disks ...
Now I know better..
> > Is it safe to remove these files manually?
>
> Yeah, if you're sure they correspond to no pg_class.relfilenode entry.
Thanks.
--
Antti Salmela
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-11-03 17:39:10 | Re: BUG #2017: column labels ignored on selects from views |
Previous Message | Alvaro Herrera | 2005-11-03 15:54:17 | Re: pg_dumpall bug & feature request |