From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Tobias Brox <tobias(at)nordicbet(dot)com>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: "nice"/low priority Query |
Date: | 2005-08-02 16:54:52 |
Message-ID: | 42EFA55C.3080903@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Tom Lane wrote:
> Tobias Brox <tobias(at)nordicbet(dot)com> writes:
>
>>Is there any ways to give postgresql a hint that a
>>particular SQL call should be run at lower priority? Since every db
>>connection has a pid, I can manually run "renice" to scheduele it by the OS
>>- but of course I can't do it manually all the time.
>
> And it won't help you anyway, because renice only affects CPU priority
> not I/O scheduling ... which, by your description, is the real problem.
>
> I think the only thing that's likely to help much is trying to arrange
> that the "simple" queries only need to touch pages that are already in
> memory. Some playing around with shared_buffer sizing might help.
> Also, if you're not on PG 8.0.*, an update might help.
Would it be useful to be able to re-use the vacuum_cost_xxx settings in
8.0 for this sort of thing? I'm thinking a long-running report query
isn't that different from a vacuum.
--
Richard Huxton
Archonet Ltd
From | Date | Subject | |
---|---|---|---|
Next Message | Jim C. Nasby | 2005-08-02 17:25:50 | Re: "nice"/low priority Query |
Previous Message | Tom Lane | 2005-08-02 16:19:30 | Re: "nice"/low priority Query |