Re: Failed CLUSTER seems to leave files behind

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

In response to

Browse pgsql-bugs by date

  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