Re: oids on disk not in pg_class

On Oct 7, 2013, at 2:48 PM, Guy Rouillier <guy(dot)rouillier(at)gmail(dot)com> wrote:

> We have a fairly large (1 TB) database we put on all SSDs because of a very high insert and update rate (). As our business has grown, we've been running into space constraints, so we went looking for files we might be able to delete.
>
> We found a large number (662 out of 1465 total ) and size (219 GB) of files in the data directory whose name does not correspond to an oid in the pg_class system catalog table. That amount of space would address our current space constraint problems. Some of these tables are recent (from today), while others are quite old (large volume in August and May, with some smaller ones as far back as February.

You need to be looking at pg_class.relfilenode, not pg_class.oid. They're often the same value, but often not.

Cheers,
Steve