Re: [BUGS] Failed CLUSTER seems to leave files behind

2005-11-03 Thread Antti Salmela
On Thu, Nov 03, 2005 at 10:03:16AM -0500, Tom Lane wrote: > Antti Salmela <[EMAIL PROTECTED]> 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 file

Re: [BUGS] Failed CLUSTER seems to leave files behind

2005-11-03 Thread Tom Lane
Antti Salmela <[EMAIL PROTECTED]> 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,

[BUGS] Failed CLUSTER seems to leave files behind

2005-11-02 Thread Antti Salmela
Failed CLUSTER due to insufficient disk space seems to leave temporary files behind at least on 7.4.7. I used the following perl script to determine if there is files which do not have corresponding entry in pg_class and timestamps of these files matched with failed CLUSTER attempts. Is it safe t