How close to Postgres does this need to be? Like could you host this on Aurora DSQL and have unlimited scalability?

Or how would you scale this to support thousands of events per second?

I’m not the OP but DSQL has such limited Postgres compatibility that it is very unlikely to be compatible.