Re: Diagnosing a massive toast file

Поиск
Список
Период
Сортировка
От Wells Oliver
Тема Re: Diagnosing a massive toast file
Дата
Msg-id CAOC+FBX1arTzF+_hx2WMsnOoF95gnnMZtNNkPUG+OKAERpisJg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Diagnosing a massive toast file  (Ron <ronljohnsonjr@gmail.com>)
Ответы Re: Diagnosing a massive toast file  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
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 по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: Diagnosing a massive toast file
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Diagnosing a massive toast file