Re: Diagnosing a massive toast file

Поиск
Список
Период
Сортировка
От Ron
Тема Re: Diagnosing a massive toast file
Дата
Msg-id 3da6ffe8-28ef-fb9a-e6e8-1f0d243cc8e9@gmail.com
обсуждение исходный текст
Ответ на Diagnosing a massive toast file  (Wells Oliver <wells.oliver@gmail.com>)
Ответы Re: Diagnosing a massive toast file  (Wells Oliver <wells.oliver@gmail.com>)
Список pgsql-admin
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 по дате отправления:

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