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
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
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
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.
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
