Cluster failure due to space

From: "Shea,Dan [CIS]" <Dan(dot)Shea(at)ec(dot)gc(dot)ca>
To: pgsql-performance(at)postgresql(dot)org
Subject: Cluster failure due to space
Date: 2004-03-10 13:56:57
Message-ID: F2D63B916C88C14D9B59F93C2A5DD33F0B919F@cisxa.cis.ec.gc.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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
writing to looks to be 40 files of 1GB.

The problem is that it did not clean itself up properly.

The oids that I believe it was writing to are still there.
There are 56 files of 102724113.* and 40 files of 361716097.*.
A vacuum had indicated that there was around 16 GB of free space.
I can not find any reference to 361716097 in the pg_class table.
Am I going to have to manually delete the 361716097.* files myself?

Dan.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Steve Atkins 2004-03-10 14:42:54 Re: optimizing large query with IN (...)
Previous Message Christopher Kings-Lynne 2004-03-10 08:38:39 Re: optimizing large query with IN (...)