Postgres Pro
Downloads
Home   >   mailing lists

Re: Cluster failure due to space - Mailing list pgsql-performance

From Tom Lane
Subject Re: Cluster failure due to space
Date
Msg-id 6731.1078932240@sss.pgh.pa.us
Whole thread Raw
In response to Cluster failure due to space  ("Shea,Dan [CIS]" <Dan.Shea@ec.gc.ca>)
List pgsql-performance
Tree view 
"Shea,Dan [CIS]" <Dan.Shea@ec.gc.ca> 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_class.relfilenode, I hope, not pg_class.oid.

            regards, tom lane

pgsql-performance by date:

Previous
From: Steve Atkins
Date:
Subject: Re: optimizing large query with IN (...)
Next
From: "Shea,Dan [CIS]"
Date:
Subject: Re: Cluster failure due to space