| From: | "Jim C(dot) Nasby" <decibel(at)decibel(dot)org> |
|---|---|
| To: | matt(at)followers(dot)net |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Preventing query from hogging server |
| Date: | 2005-03-28 21:05:59 |
| Message-ID: | 20050328210559.GC51784@decibel.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Thu, Mar 24, 2005 at 01:07:39PM -0600, Matthew Nuzum wrote:
> I've tried `nice psql` in the past and I don't think that had much impact,
> but I haven't tried it on this query.
On linux, nice will only help if the query is CPU-bound. On FreeBSD,
nice affects I/O scheduling, as well as CPU, so it's a more effective
means of limiting the impact of large queries. I don't know how other
OS's handle this.
--
Jim C. Nasby, Database Consultant decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2005-03-28 21:07:25 | Re: Delete query takes exorbitant amount of time |
| Previous Message | Joshua D. Drake | 2005-03-28 20:57:08 | Re: which dual-CPU hardware/OS is fastest for PostgreSQL? |