Re: maintenance_work_mem and autovacuum

Поиск
Список
Период
Сортировка
От Bernd Helmle
Тема Re: maintenance_work_mem and autovacuum
Дата
Msg-id 86D5C19DB18D86789964F7D9@teje
обсуждение исходный текст
Ответ на Re: maintenance_work_mem and autovacuum  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-hackers
--On Donnerstag, März 26, 2009 13:43:45 -0700 Josh Berkus
<josh@agliodbs.com> wrote:

> I actually have a client who does both automated and manual vacuums.
> Having two settings would definitely be convenient for them.

I often found people doing this running within a) their own superuser with
special GUCs set or b) using their own scripts which are setting
maintenance_work_mem accordingly.

Often people are very confused about the number of *_vaccum_* settings
already present: they sometimes have a really hard time to learn the
difference between manual and auto vaccum and the interaction of
default/inherited settings.

That said, having a separate setting would be consequent, but it seems to
me it's enough there to satisfy all needs, isn't it?

--  Thanks
                   Bernd


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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: maintenance_work_mem and autovacuum
Следующее
От: Emmanuel Cecchet
Дата:
Сообщение: Re: Partitioning feature ...