Postgres Pro
Downloads
Home   >   mailing lists

Diagnosing a massive toast file - Mailing list pgsql-admin

From Wells Oliver
Subject Diagnosing a massive toast file
Date
Msg-id CAOC+FBUPopsKh5wV5VC-CHCnVirtTghhwNwEtSD2ZaCZbXwOFg@mail.gmail.com
Whole thread Raw
Responses Re: Diagnosing a massive toast file  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-admin
Tree view
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.

--

pgsql-admin by date:

Previous
From: Mark Steben
Date:
Subject: Re: Streaming replication question
Next
From: Ron
Date:
Subject: Re: Diagnosing a massive toast file