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

[Luke Lonergan]

Mark,

> Yes. We might be able to mitigate some of that with some form 
> of prioritization or similar.

Batch queueing - If you have checkpoint and restart capability you can
arbitrarily stop and restart jobs, many times on a schedule for each
queue.  The nighttime queue is reserved for long running jobs, sometimes
the nightime queue would be designed to arbitrarily terminate jobs at
the end of their allocated timeframe.  The interactive queues would be
run with differing numbers of allowable jobs depending on the schedule,
so at night there might be far fewer slots for interactive.

Interactive queues would also often run with a time limit and the jobs
would be killed if they exceeded that time allotment.

At least with a queueing infrastructure like this, you can manage the
resources and enforce policy.

- Luke