Re: [PERFORM] autovacuum: use case for indenpedent TOAST table autovac settings

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [PERFORM] autovacuum: use case for indenpedent TOAST table autovac settings
Дата
Msg-id 18539.1218675190@sss.pgh.pa.us
обсуждение исходный текст
Ответ на autovacuum: use case for indenpedent TOAST table autovac settings  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: [PERFORM] autovacuum: use case for indenpedent TOAST table autovac settings  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Does anyone see a need for having TOAST tables be individually
> configurable for autovacuum?  I've finally come around to looking at
> being able to use ALTER TABLE for autovacuum settings, and I'm wondering
> if we need to support that case.

It seems like we'll want to do it somehow.  Perhaps the cleanest way is
to incorporate toast-table settings in the reloptions of the parent
table.  Otherwise dump/reload is gonna be a mess.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: SeqScan costs
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: [PERFORM] autovacuum: use case for indenpedent TOAST table autovac settings