Durch die Nutzung von AWS re:Post stimmt du den AWS re:Post Nutzungsbedingungen

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 Antwort
1
Akzeptierte Antwort

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
beantwortet vor 8 Monaten
profile picture
EXPERTE
überprüft vor 8 Monaten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen