How to reference DBInstanceVCPU in RDS parameter?

0

Per the docs here, DBInstanceVCPU should be supported.

However, I've noted that in the default.aurora-postgresql13 this seems to be formatted differently (note the $ vs lack thereof):

max_connections : LEAST({DBInstanceClassMemory/9531392},5000)
max_parallel_workers : GREATEST(${DBInstanceVCPU/2},8)

Moreover, if I try to create a custom parameter group and edit max_parallel_workers by simply changing the 8 to another integer, the UI refuses to accept anything with DBInstanceVCPU (with or without the $).

Is this an issue with the RDS UI's parameter validation or is there something else that I'm missing?

Thanks!

1 réponse
1
Réponse acceptée

Hello,

Please note, I confirm this is a known issue and currently the "DBInstanceVCPU" cannot be used/re-used in parameter value when being modified from customer's end. This makes "DBInstanceVCPU" unusable for customer. Apologies, that AWS public documentation [1] is misleading and I will report it to our internal team.

Example:  
max_parallel_workers={DBInstanceVCPU/4*3} ----> is not accepted as a valid entry
Example:
max_parallel_workers=GREATEST({DBInstanceVCPU*3/4},1) ----> is accepted as a valid entry

Reference

[1] Working with DB parameter groups - DB parameter formulas - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithParamGroups.html#USER_ParamFormulas

Hope it helps and if it does, I would appreciate if answer can be accepted so that community can benefit for clarity when searching for similar enquiries in repost/aws guide.

Thank you!

AWS
répondu il y a 3 mois
profile picture
EXPERT
vérifié il y a 3 mois

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions