Setting "nice" values

Поиск
Список
Период
Сортировка
От Madison Kelly
Тема Setting "nice" values
Дата
Msg-id 454A0B69.9070000@alteeve.com
обсуждение исходный текст
Ответы Re: Setting "nice" values  (Scott Marlowe <smarlowe@g2switchworks.com>)
Re: Setting "nice" values  (Jim Nasby <decibel@decibel.org>)
Список pgsql-performance
Hi all,

   I've got a script (perl, in case it matters) that I need to run once
a month to prepare statements. This script queries and updates the
database a *lot*. I am not concerned with the performance of the SQL
calls so much as I am about the impact it has on the server's load.

   Is there a way to limit queries speed (ie: set a low 'nice' value on
a query)? This might be an odd question, or I could be asking the
question the wrong way, but hopefully you the idea. :)

Thanks!

Madi


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

Предыдущее
От: "Dave Dutcher"
Дата:
Сообщение: Re: Query plan for "heavy" SELECT with "lite" sub-SELECTs
Следующее
От: "Steven Flatt"
Дата:
Сообщение: Re: Database-wide vacuum can take a long time, duringwhich tables are not being analyzed