[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