From: Madison Kelly <linux@alteeve.com>
To: Andreas Kostyrka <andreas@kostyrka.org>
Cc: Scott Marlowe <smarlowe@g2switchworks.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Setting "nice" values
Date: Mon, 06 Nov 2006 08:13:52 -0500
Message-ID: <454F3510.2060804@alteeve.com> (raw)
In-Reply-To: <1162560864.16439.1.camel@andi-lap>
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: linux@alteeve.com, andreas@kostyrka.org, smarlowe@g2switchworks.com
Subject: Re: Setting "nice" values
In-Reply-To: <454F3510.2060804@alteeve.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox