Cluster failure due to space - Mailing list pgsql-performance

From Shea,Dan [CIS]
Subject Cluster failure due to space
Date
Msg-id F2D63B916C88C14D9B59F93C2A5DD33F0B919F@cisxa.cis.ec.gc.ca
Whole thread Raw
Responses Re: Cluster failure due to space
List 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.

pgsql-performance by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: optimizing large query with IN (...)
Next
From: Steve Atkins
Date:
Subject: Re: optimizing large query with IN (...)