Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id EAF659FA432 for ; Thu, 2 Nov 2006 11:15:23 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 92844-08 for ; Thu, 2 Nov 2006 15:15:19 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from white.netsurf.net (white.NetSurf.Net [66.135.102.134]) by postgresql.org (Postfix) with ESMTP id C78519FA3B4 for ; Thu, 2 Nov 2006 11:15:18 -0400 (AST) Received: from [10.42.124.48] (synapticv-96.43.ADSL.NetSurf.Net [66.135.96.43]) by white.netsurf.net (8.13.4/8.13.4/Debian-3sarge3) with ESMTP id kA2FFEdu031194 for ; Thu, 2 Nov 2006 10:15:16 -0500 Message-ID: <454A0B69.9070000@alteeve.com> Date: Thu, 02 Nov 2006 10:14:49 -0500 From: Madison Kelly User-Agent: Thunderbird 1.5.0.7 (X11/20060909) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Setting "nice" values Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/24 X-Sequence-Number: 21794 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