[Bizgres-general] Statement Queuing take II - Resource Scheduling

Mark Kirkwood mkirkwood at greenplum.com
Thu Jun 29 05:34:26 UTC 2006


Josh Berkus wrote:
>
>
>> One question is what about roles assigned to other roles? Do you always
>> use the limits of the lowest role in the tree, or are limits cumulative?
>
> Lowest role in the tree.   Otherwise, it's a foot-gun.
>
>

I'm coming back to this, as I've gotten myself confused after thinking 
about it some more :-).

I wondering about the definition of 'lowest role in the tree':

 If it is 'the role with the lowest resource limits', then this is 
potentially not defined when there is more than one resource limit type 
- e.g. (inventing some extra limit types as we go) suppose  role 'A' has 
cpu limit 90 and memory limit 80  and role 'B' has  them the other way 
around, if I am a member of 'A' and 'B' it is not possible to decide 
which role to use with this definition.

If it means the 'the role closest to us in the membership list', then 
this can also suffer from 2 roles being equally 'close'.

I'm wondering if there needs to be a check along the lines of 'you can 
only be a member of 1 group with resource limits enabled'?

Any thoughts (of have I just missed something obvious)?

Cheers

Mark


More information about the Bizgres-general mailing list