Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 764DE9FAE4E for ; Mon, 6 Nov 2006 09:15:01 -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 65637-09 for ; Mon, 6 Nov 2006 13:14:57 +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 160C49FA173 for ; Mon, 6 Nov 2006 09:14:56 -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 kA6DEkQH005831; Mon, 6 Nov 2006 08:14:49 -0500 Message-ID: <454F3510.2060804@alteeve.com> Date: Mon, 06 Nov 2006 08:13:52 -0500 From: Madison Kelly User-Agent: Thunderbird 1.5.0.7 (X11/20060909) MIME-Version: 1.0 To: Andreas Kostyrka CC: Scott Marlowe , 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> <1162560864.16439.1.camel@andi-lap> In-Reply-To: <1162560864.16439.1.camel@andi-lap> 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/60 X-Sequence-Number: 21830 Andreas Kostyrka wrote: > Am Donnerstag, den 02.11.2006, 09:41 -0600 schrieb Scott Marlowe: >> Sometimes it's the simple solutions that work best. :) Welcome to the >> world of pgsql, btw... > > OTOH, there are also non-simple solutions to this, which might make > sense anyway: Install slony, and run your queries against a readonly > replica of your data. Bingo! This seems like exactly what we can/should do, and it will likely help with other jobs we run, too. I feel a little silly for not having thought of this myself... Guess I was too focused on niceness :). Thanks! Madi