| From: | Madison Kelly <linux(at)alteeve(dot)com> |
|---|---|
| To: | Andreas Kostyrka <andreas(at)kostyrka(dot)org> |
| Cc: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Setting "nice" values |
| Date: | 2006-11-06 13:13:52 |
| Message-ID: | 454F3510.2060804@alteeve.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tobias Brox | 2006-11-06 13:33:53 | Re: Setting "nice" values |
| Previous Message | Madison Kelly | 2006-11-06 13:12:48 | Re: Setting "nice" values |