Re: Setting "nice" values - Mailing list pgsql-performance

From Madison Kelly
Subject Re: Setting "nice" values
Date
Msg-id 454F3510.2060804@alteeve.com
Whole thread Raw
In response to Re: Setting "nice" values  (Andreas Kostyrka <andreas@kostyrka.org>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Madison Kelly
Date:
Subject: Re: Setting "nice" values
Next
From: Tobias Brox
Date:
Subject: Re: Setting "nice" values