Postgres Pro
Downloads
Home   >   mailing lists

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

From Ron
Subject Re: Diagnosing a massive toast file
Date
Msg-id 3da6ffe8-28ef-fb9a-e6e8-1f0d243cc8e9@gmail.com
Whole thread Raw
In response to Diagnosing a massive toast file  (Wells Oliver <wells.oliver@gmail.com>)
Responses Re: Diagnosing a massive toast file  (Wells Oliver <wells.oliver@gmail.com>)
List pgsql-admin
Tree view
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: Wells Oliver
Date:
Subject: Diagnosing a massive toast file
Next
From: Wells Oliver
Date:
Subject: Re: Diagnosing a massive toast file