From: Alan Hodgson <ahodgson@simkin.ca>
Organization: Simkin Network Consulting
To: pgsql-performance@postgresql.org
Subject: Re: cpu throttling
Date: Thu, 2 Aug 2007 09:14:37 -0700
User-Agent: KMail/1.9.5
References: <bd8531800708020902v5e6a0928ted3721f3eb543dc8@mail.gmail.com>
In-Reply-To: <bd8531800708020902v5e6a0928ted3721f3eb543dc8@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200708020914.37180@hal.medialogik.com>

On Thursday 02 August 2007 09:02, "Bryan Murphy" <bryan.murphy@gmail.com> 
wrote:
> My question:  Is there a way I can decrease the priority of a specific
> query, or determine the PID of the process it is running in?  I'd like
> to throw together a quick shell script if at all possible, as right
> now I have to monitor the process manually and we'll have fixed the
> problem long before we have the chance to implement proper database
> clustering.

select procpid from pg_stat_activity  where current_query   
   like '%stored_proc%' and current_query not like '%pg_stat_activity%';

requires stats_command_string to be enabled

I'm surprised your operating system doesn't automatically lower the priority 
of the process, though ..

-- 
"Remember when computers were frustrating because they did exactly what
you told them to?  That actually seems sort of quaint now." --J.D. Baldwin