Message-ID: <454F34D0.8000207@alteeve.com>
Date: Mon, 06 Nov 2006 08:12:48 -0500
From: Madison Kelly <linux@alteeve.com>
User-Agent: Thunderbird 1.5.0.7 (X11/20060909)
MIME-Version: 1.0
To: Scott Marlowe <smarlowe@g2switchworks.com>
CC: pgsql-performance@postgresql.org
Subject: Re: Setting "nice" values
References: <454A0B69.9070000@alteeve.com>	
	<1162480836.28047.20.camel@state.g2switchworks.com>	
	<454A0DD3.2050104@alteeve.com>
	<1162482071.28047.39.camel@state.g2switchworks.com>
In-Reply-To: <1162482071.28047.39.camel@state.g2switchworks.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Scott Marlowe wrote:
> nope, the priorities don't pass down.  you connect via a client lib to
> the server, which spawns a backend process that does the work for you. 
> The backend process inherits its priority from the postmaster that
> spawns it, and they all run at the same priority.

Shoot, but figured. :)

>> Thanks for the tip, too, it's something I will try.
> 
> Sometimes it's the simple solutions that work best.  :)  Welcome to the
> world of pgsql, btw...

Heh, if only I was new to pgsql I wouldn't feel silly for asking so many 
questions :P. In the same right though, I enjoy PgSQL/Linux/FOSS in 
general *because* there seems to never be a shortage of things to learn.

Thanks!

Madi