Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Setting "nice" values
- From: Jim Nasby <decibel(at)decibel(dot)org>
- To: Madison Kelly <linux(at)alteeve(dot)com>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Setting "nice" values
- Date: Sun, 5 Nov 2006 22:27:48 -0600
- Message-id: <D78EEA00-E5D9-40BE-9096-DF36F7A8A9C3(at)decibel(dot)org>
On Nov 2, 2006, at 9:14 AM, Madison Kelly wrote:
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. :)
The BizGres folks have been working on resource queuing, which will eventually do what you want. Take a look at the BizGres mailing list archives for more info.
-- Jim Nasby jim(at)nasby(dot)net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
- References:
- Setting "nice" values
- From: Madison Kelly
- Setting "nice" values
- Prev by Date: Re: Slow functional indexes?
- Next by Date: Re: Setting "nice" values
- Previous by thread: Re: Setting "nice" values
- Next by thread: Re: Setting "nice" values
- Indexes: