Subject: Re: Diagnosing a massive toast file
To: pgsql-admin@lists.postgresql.org
References: 
 <CAOC+FBUPopsKh5wV5VC-CHCnVirtTghhwNwEtSD2ZaCZbXwOFg@mail.gmail.com>
From: Ron <ronljohnsonjr@gmail.com>
Message-ID: <3da6ffe8-28ef-fb9a-e6e8-1f0d243cc8e9@gmail.com>
Date: Mon, 5 Aug 2019 11:36:27 -0500
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101
 Thunderbird/60.7.2
MIME-Version: 1.0
In-Reply-To: 
 <CAOC+FBUPopsKh5wV5VC-CHCnVirtTghhwNwEtSD2ZaCZbXwOFg@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------D0CF83721208E02237EDEC6E"
Content-Language: en-US
Precedence: bulk

This is a multi-part message in MIME format.
--------------D0CF83721208E02237EDEC6E
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit

On 8/5/19 11:32 AM, Wells Oliver wrote:
> Hi all, I have not seen this before, but one our toast tables has gotten 
> to 15GB, the biggest table in the DB. I don't know why, is there some way 
> I can diagnose what's causing this?
>
>  I don't think I've ever seen a toast table even half of this size, so 
> it's concerning.

We've got *lots* of toast tables that big.  Are you asking how to find the 
"human readable name" associated with the toast table?

And have you vacuumed it lately?

-- 
Angular momentum makes the world go 'round.

--------------D0CF83721208E02237EDEC6E
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    On 8/5/19 11:32 AM, Wells Oliver wrote:<br>
    <blockquote type="cite"
cite="mid:CAOC+FBUPopsKh5wV5VC-CHCnVirtTghhwNwEtSD2ZaCZbXwOFg@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <div>Hi all, I have not seen this before, but one our toast
          tables has gotten to 15GB, the biggest table in the DB. I
          don't know why, is there some way I can diagnose what's
          causing this?</div>
        <div><br>
        </div>
        <div> I don't think I've ever seen a toast table even half of
          this size, so it's concerning.<br>
        </div>
      </div>
    </blockquote>
    <br>
    We've got <b>lots</b> of toast tables that big.  Are you asking how
    to find the "human readable name" associated with the toast table?<br>
    <br>
    And have you vacuumed it lately?<br>
    <br>
    <div class="moz-signature">-- <br>
      Angular momentum makes the world go 'round.</div>
  </body>
</html>

--------------D0CF83721208E02237EDEC6E--