Re: [PERFORM] Cluster failure due to space

2004-03-10 Thread Shea,Dan [CIS]
"Shea,Dan [CIS]" <[EMAIL PROTECTED]> writes: >> The problem is that it did not clean itself up properly. >Hm. It should have done so. What were the exact filenames and sizes of >the not-deleted files? 361716097 to 361716097.39 are 1073741824 bytes. 361716097.40 is 186105856 bytes. > I can

Re: [PERFORM] Cluster failure due to space

2004-03-10 Thread Tom Lane
"Shea,Dan [CIS]" <[EMAIL PROTECTED]> writes: > The problem is that it did not clean itself up properly. Hm. It should have done so. What were the exact filenames and sizes of the not-deleted files? > I can not find any reference to 361716097 in the pg_class table. You are looking at pg_cla

[PERFORM] Cluster failure due to space

2004-03-10 Thread Shea,Dan [CIS]
I have had a cluster failure on a table. It most likely was due to space. I do not not have the error message anymore, but it was indicating that it was most likely a space problem. The partition was filled to 99%. The table is about 56 GB and what I believe to be the new table that it was writi