I tested on Aurora when it launched the PostgreSQL compatibility and it worked pretty well back then, so I assume it will be the same here.
That said, Discourse scales pretty well on a single managed PostgreSQL vertically, so I’m interested in how much activity you see that trying something like this would make sense from a risk-reward perspective.