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

[Mark Kirkwood]

Luke Lonergan wrote:
> Mark, 
>
>   
>> While we are talking outgrowths, administrators will probably 
>> want the ability to suspend or wakeup queued queries - or 
>> even reassign 'em to a different queues...
>>     
>
> That is actually a potential work-around if we don't have the time
> sharing capability.  An admin would have to put a hoggy query to sleep,
> allowing others to continue, then restart it later.
>
> This could even be a useful first step toward time slicing.
>
>   

Yeah - it would also let us (manually, or with quick hackery) test out 
some time sharing scenarios, before building the whole beast :-).

> The analogy is to "batch queueing", where jobs are managed this way.
> Batch queueing allows administrators to manage the queues to correct
> problems and generally maximize throughput.  In batch queueing, there
> are always hogs to worry about.
>
>
>   
Yes. We might be able to mitigate some of that with some form of 
prioritization or similar.

Cheers

Mark