Setting "nice" values

From: Madison Kelly <linux(at)alteeve(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Setting "nice" values
Date: 2006-11-02 15:14:49
Message-ID: 454A0B69.9070000@alteeve.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Steven Flatt 2006-11-02 15:15:30 Re: Database-wide vacuum can take a long time, duringwhich tables are not being analyzed
Previous Message Dave Dutcher 2006-11-02 14:25:27 Re: Query plan for "heavy" SELECT with "lite" sub-SELECTs