Re: best way to run maintenance script

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: best way to run maintenance script
Дата
Msg-id 200803161911.49571.peter_e@gmx.net
обсуждение исходный текст
Ответ на best way to run maintenance script  (Vinubalaji Gopal <vgopal@abaca.com>)
Список pgsql-performance
Vinubalaji Gopal wrote:
> I tried using the nice command (Linux system) on the maintenance script
> - it did not have any effect - guess it does not change the niceness of
> the postgresql vacuum process.

You are probably looking for the command ionice.  nice only affects the CPU
priority, and that is usually not the primary problem for vacuum.  (And yes,
you need to nice the server process, not the client script.)

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

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
Следующее
От: Craig James
Дата:
Сообщение: Re: Benchmark: Dell/Perc 6, 8 disk RAID 10