Postgres Pro
Downloads
Home   >   mailing lists

Re: Diagnosing a massive toast file - Mailing list pgsql-admin

From Wells Oliver
Subject Re: Diagnosing a massive toast file
Date
Msg-id CAOC+FBX1arTzF+_hx2WMsnOoF95gnnMZtNNkPUG+OKAERpisJg@mail.gmail.com
Whole thread Raw
In response to Re: Diagnosing a massive toast file  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: Diagnosing a massive toast file
List pgsql-admin
Tree view
Yeah, trying to figure out what actual table is clearly in need of a vacuum b/c of the size of that toast table.

On Mon, Aug 5, 2019 at 9:36 AM Ron <ronljohnsonjr@gmail.com> wrote:
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.


--

pgsql-admin by date:

Previous
From: Ron
Date:
Subject: Re: Diagnosing a massive toast file
Next
From: Tom Lane
Date:
Subject: Re: Diagnosing a massive toast file