[Bizgres-general] Off-list Re: [ENG] Re: Statement Queuing take II - Resource Scheduling (Running with cost and cursors)

[Jim C. Nasby]

On Sun, Aug 06, 2006 at 10:31:43PM -0400, Luke Lonergan wrote:
> If we were only talking about CPU and memory utilization (your N is
> memory in this case), then you would be right.  In the case of interest,
> where the non-linear disk sharing is the problem, this is describing an
> overhead.

Take off the MPP goggles for a second... ;) I think one of the biggest
targets for queuing is to improve how work_mem is handled, especially in
mixed-workload environments. For certain dataset sizes, increasing
work_mem for large queries will have an enormous effect, because it
prevents spilling to disk, but unless you have very tight control over
how those queries are run you'll never be able to do that without
pushing the machine into swapping.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby at pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461