Re: how to limit postgresql process and memory time

Поиск
Список
Период
Сортировка
От Brent Verner
Тема Re: how to limit postgresql process and memory time
Дата
Msg-id 20020117112508.A41604@rcfile.org
обсуждение исходный текст
Ответ на Re: how to limit postgresql process and memory time  (Jan Wieck <janwieck@yahoo.com>)
Ответы Re: how to limit postgresql process and memory time  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
[2002-01-17 10:26] Jan Wieck said:
| Emmanuel SARACCO wrote:
| > hi,
| >
| > how can I limit all my postgresql processes to a certain percent of
| > processor work and a maximum amount of memory.
| > for exemple, to limit postgresql to 50% of processor work and 250mo of
| > memory.
|
|     I  don't  know  of  any  UNIX  operating  system  that can be
|     configured that way. You might have to look into some virtual
|     machine architectures.

Would it be useful to have settings for nice(2) and setrlimit(2)
calls?  I can see the utility in having setrlimit, but I get the
feeling nice is not something we want to put a knob on.

  b

--
"Develop your talent, man, and leave the world something. Records are
really gifts from people. To think that an artist would love you enough
to share his music with anyone is a beautiful thing."  -- Duane Allman

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

Предыдущее
От: "Ian Harding"
Дата:
Сообщение: Re: Kindly help.
Следующее
От: Christian Schröder
Дата:
Сообщение: Re: pg_dump behaviour changed in 7.1.3?