Re: autovacuum next steps, take 2

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas ADI SD
Тема Re: autovacuum next steps, take 2
Дата
Msg-id E1539E0ED7043848906A8FF995BDA57901CAF5E0@m0143.s-mxs.net
обсуждение исходный текст
Ответ на Re: autovacuum next steps, take 2  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: autovacuum next steps, take 2  ("Jim C. Nasby" <jim@nasby.net>)
Список pgsql-hackers
> vacuum should be a process with the least amount of voodoo.
> If we can just have vacuum_delay and vacuum_threshold, where
> threshold allows an arbitrary setting of how much bandwidth
> we will allot to the process, then that is a beyond wonderful thing.
>
> It is easy to determine how much IO you have, and what you can spare.

The tricky part is what metric to use. Imho "IO per second" would be
good.
In a typical DB scenario that is the IO bottleneck, not the Mb/s.

Andreas


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

Предыдущее
От: "Nikolay Samokhvalov"
Дата:
Сообщение: Re: --enable-xml instead of --with-libxml?
Следующее
От: Gregory Stark
Дата:
Сообщение: Re: SCMS question