Re: [GENERAL] oids on disk not in pg_class

2013-10-07 Thread Guy Rouillier
On 10/7/2013 6:46 PM, David Kerr wrote: On Mon, Oct 07, 2013 at 06:32:57PM -0400, Guy Rouillier wrote: - So, I ran "select pg_relation_filenode(614804)" and got no results. Any - suggestions on how I can uncover the identify of this node? - - Thanks much. You could try oid2name: http://www.post

Re: [GENERAL] oids on disk not in pg_class

2013-10-07 Thread David Kerr
On Mon, Oct 07, 2013 at 06:32:57PM -0400, Guy Rouillier wrote: - On 10/7/2013 5:58 PM, Steve Atkins wrote: - > - >On Oct 7, 2013, at 2:48 PM, Guy Rouillier - >wrote: - > - >>We have a fairly large (1 TB) database we put on all SSDs because - >>of a very high insert and update rate (38 million rows

Re: [GENERAL] oids on disk not in pg_class

2013-10-07 Thread Guy Rouillier
On 10/7/2013 5:58 PM, Steve Atkins wrote: On Oct 7, 2013, at 2:48 PM, Guy Rouillier wrote: We have a fairly large (1 TB) database we put on all SSDs because of a very high insert and update rate (38 million rows/day). As our business has grown, we've been running into space constraints, so w

Re: [GENERAL] oids on disk not in pg_class

2013-10-07 Thread Steve Atkins
On Oct 7, 2013, at 2:48 PM, Guy Rouillier 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.