Re: Diagnosing a massive toast file

Ron <ronljohnsonjr@xxxxxxxxx> · Mon, 5 Aug 2019 11:36:27 -0500



    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.