oids on disk not in pg_class

From: Guy Rouillier <guy(dot)rouillier(at)gmail(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: oids on disk not in pg_class
Date: 2013-10-07 21:48:34
Message-ID: 52532C32.3080001@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

What kinds of data are written to disk without being registered in
pg_class? How can we determine which (if any) are safe to delete?

Thanks.

--
Guy Rouillier

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Atkins 2013-10-07 21:58:42 Re: oids on disk not in pg_class
Previous Message Jeff Janes 2013-10-07 19:33:14 Re: pg_xlog size growing untill it fills the partition