Huge pg_toast table

Поиск
Список
Период
Сортировка
От Ed L.
Тема Huge pg_toast table
Дата
Msg-id 200307241453.26503.pgsql@bluepolka.net
обсуждение исходный текст
Ответы Re: Huge pg_toast table  ("Ed L." <pgsql@bluepolka.net>)
Список pgsql-general
I have a frequently updated table called 'audit' with 10,000 rows of about
90kb per row (90kb * 10k = 900mb).  There is a 35gb system table called
pg_toast_NNNNN where NNNNN is the oid of the 'audit' table.

My question:  should I expect a 'vacuum full' to shrink the size of this
pg_toast table?  I ask instead of just doing it because doing so would
require scheduling customer downtime since 'vacuum full' blocks access.

TIA.


В списке pgsql-general по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: dump_all/restore times?
Следующее
От: "Ed L."
Дата:
Сообщение: Re: Huge pg_toast table